PREVIEW / stock_30min / 2008-08-12

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-08-12.parquet
  size:    1.2 MB
  rows:    69,009
  symbols: 3,322

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2008-08-12 06:30:00	AAPL	Stock	6.18	6.1854	6.18	6.1854	11200.0
2008-08-12 07:00:00	AAPL	Stock	6.2043	6.2461	6.1789	6.2461	421652.0
2008-08-12 07:30:00	AAPL	Stock	6.2496	6.2546	6.2339	6.2339	429016.0
2008-08-12 08:00:00	AAPL	Stock	6.2443	6.2443	6.2043	6.2071	1246980.0
2008-08-12 08:30:00	AAPL	Stock	6.2089	6.2246	6.1768	6.1875	1406496.0
2008-08-12 09:00:00	AAPL	Stock	6.1825	6.2125	6.1746	6.1986	2069424.0
2008-08-12 09:30:00	AAPL	Stock	6.1986	6.3214	6.1968	6.3125	132031620.0
2008-08-12 10:00:00	AAPL	Stock	6.3132	6.4032	6.3071	6.3257	133389564.0
2008-08-12 10:30:00	AAPL	Stock	6.3246	6.375	6.3139	6.3732	77517608.0
2008-08-12 11:00:00	AAPL	Stock	6.3736	6.3843	6.3396	6.3825	54989704.0
2008-08-12 11:30:00	AAPL	Stock	6.3825	6.3893	6.3439	6.3532	50707664.0
2008-08-12 12:00:00	AAPL	Stock	6.3521	6.3636	6.3346	6.3568	31757404.0
2008-08-12 12:30:00	AAPL	Stock	6.3557	6.3732	6.345	6.3721	26476800.0
2008-08-12 13:00:00	AAPL	Stock	6.3718	6.3746	6.3257	6.3325	36488144.0
2008-08-12 13:30:00	AAPL	Stock	6.3325	6.3679	6.3214	6.3457	37177252.0
2008-08-12 14:00:00	AAPL	Stock	6.3439	6.375	6.3386	6.3657	31491712.0
2008-08-12 14:30:00	AAPL	Stock	6.3661	6.3661	6.3318	6.3386	42530740.0
2008-08-12 15:00:00	AAPL	Stock	6.3382	6.3471	6.2143	6.3043	79456216.0
2008-08-12 15:30:00	AAPL	Stock	6.304	6.3207	6.2811	6.3171	75206516.0
2008-08-12 16:00:00	AAPL	Stock	6.3171	6.3429	6.3071	6.3107	9519972.0
2008-08-12 16:30:00	AAPL	Stock	6.3125	6.3171	6.3089	6.3143	2256212.0
2008-08-12 17:00:00	AAPL	Stock	6.3143	6.3211	6.3143	6.3211	192444.0
2008-08-12 17:30:00	AAPL	Stock	6.3211	6.3261	6.3207	6.3211	118860.0
2008-08-12 18:00:00	AAPL	Stock	6.3275	6.3275	6.3179	6.3261	262416.0
2008-08-12 18:30:00	AAPL	Stock	6.3211	6.3254	6.3168	6.3254	46256.0
2008-08-12 19:00:00	AAPL	Stock	6.3214	6.3214	6.3196	6.3211	21812.0
2008-08-12 19:30:00	AAPL	Stock	6.32	6.3246	6.32	6.3214	71008.0
2008-08-12 07:30:00	MSFT	Stock	28.0	28.0	28.0	28.0	200.0
2008-08-12 08:00:00	MSFT	Stock	27.77	27.95	27.77	27.9	3900.0
2008-08-12 08:30:00	MSFT	Stock	27.9	27.9	27.77	27.82	5400.0
2008-08-12 09:00:00	MSFT	Stock	27.82	27.89	27.73	27.76	5328.0
2008-08-12 09:30:00	MSFT	Stock	27.76	27.89	27.68	27.73	7409010.0
2008-08-12 10:00:00	MSFT	Stock	27.73	27.86	27.7	27.74	3990006.0
2008-08-12 10:30:00	MSFT	Stock	27.73	27.74	27.58	27.69	6484205.0
2008-08-12 11:00:00	MSFT	Stock	27.69	28.3	27.67	28.26	5407589.0
2008-08-12 11:30:00	MSFT	Stock	28.25	28.36	28.18	28.23	6359107.0
2008-08-12 12:00:00	MSFT	Stock	28.23	28.23	28.12	28.17	2375898.0
2008-08-12 12:30:00	MSFT	Stock	28.17	28.18	28.06	28.14	2208932.0
2008-08-12 13:00:00	MSFT	Stock	28.14	28.16	28.08	28.12	2456754.0
2008-08-12 13:30:00	MSFT	Stock	28.12	28.24	28.07	28.14	2528196.0
2008-08-12 14:00:00	MSFT	Stock	28.14	28.35	28.13	28.31	2683015.0
2008-08-12 14:30:00	MSFT	Stock	28.32	28.32	28.17	28.17	3564722.0
2008-08-12 15:00:00	MSFT	Stock	28.18	28.2	28.02	28.15	5753980.0
2008-08-12 15:30:00	MSFT	Stock	28.15	28.17	28.03	28.14	6966729.0
2008-08-12 16:00:00	MSFT	Stock	28.16	28.2	28.002	28.012	1828914.0
2008-08-12 16:30:00	MSFT	Stock	28.12	28.12	28.1	28.1	372780.0
2008-08-12 17:00:00	MSFT	Stock	28.14	28.14	28.14	28.14	100.0
2008-08-12 17:30:00	MSFT	Stock	28.15	28.15	28.15	28.15	125.0
2008-08-12 18:00:00	MSFT	Stock	28.15	28.15	28.12	28.12	16586.0
2008-08-12 20:00:00	MSFT	Stock	28.29	28.29	28.29	28.29	561.0

> showing 50 of 69,009 rows — these rows as CSV

> unlock the full archive -- $79 one-time