PREVIEW / stock_30min / 2008-08-21

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-08-21.parquet
  size:    1.2 MB
  rows:    67,776
  symbols: 3,293

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-21 04:30:00	AAPL	Stock	6.2504	6.2504	6.2504	6.2504	5600.0
2008-08-21 05:30:00	AAPL	Stock	6.2236	6.2236	6.2236	6.2236	19600.0
2008-08-21 07:30:00	AAPL	Stock	6.2711	6.2711	6.2393	6.2396	51800.0
2008-08-21 08:00:00	AAPL	Stock	6.2482	6.2568	6.2396	6.2457	516264.0
2008-08-21 08:30:00	AAPL	Stock	6.245	6.2614	6.2364	6.2396	770588.0
2008-08-21 09:00:00	AAPL	Stock	6.2411	6.2429	6.2239	6.2311	2247336.0
2008-08-21 09:30:00	AAPL	Stock	6.2304	6.2571	6.1704	6.2471	78825264.0
2008-08-21 10:00:00	AAPL	Stock	6.2475	6.2661	6.1864	6.1929	60891796.0
2008-08-21 10:30:00	AAPL	Stock	6.1932	6.1964	6.1493	6.1668	58680888.0
2008-08-21 11:00:00	AAPL	Stock	6.1675	6.1721	6.1389	6.1714	44204188.0
2008-08-21 11:30:00	AAPL	Stock	6.1718	6.1925	6.1561	6.1764	28654472.0
2008-08-21 12:00:00	AAPL	Stock	6.1757	6.1921	6.1468	6.1554	28175868.0
2008-08-21 12:30:00	AAPL	Stock	6.1546	6.1632	6.1464	6.1532	11738832.0
2008-08-21 13:00:00	AAPL	Stock	6.1536	6.1964	6.1514	6.1764	25330872.0
2008-08-21 13:30:00	AAPL	Stock	6.1764	6.2071	6.17	6.2029	26709340.0
2008-08-21 14:00:00	AAPL	Stock	6.2018	6.2493	6.1929	6.24	38900204.0
2008-08-21 14:30:00	AAPL	Stock	6.2407	6.2654	6.225	6.2268	40632004.0
2008-08-21 15:00:00	AAPL	Stock	6.2268	6.2529	6.2111	6.2386	37359924.0
2008-08-21 15:30:00	AAPL	Stock	6.2392	6.2657	6.2179	6.2229	44474080.0
2008-08-21 16:00:00	AAPL	Stock	6.2243	6.2374	6.2064	6.2271	4846240.0
2008-08-21 16:30:00	AAPL	Stock	6.2286	6.235	6.2275	6.2321	84420.0
2008-08-21 17:00:00	AAPL	Stock	6.2229	6.2311	6.2161	6.225	264824.0
2008-08-21 17:30:00	AAPL	Stock	6.225	6.225	6.225	6.225	14000.0
2008-08-21 18:00:00	AAPL	Stock	6.225	6.2286	6.225	6.2286	91784.0
2008-08-21 19:30:00	AAPL	Stock	6.2282	6.2282	6.2146	6.2161	240660.0
2008-08-21 04:00:00	MSFT	Stock	27.16	27.16	27.16	27.16	100.0
2008-08-21 08:00:00	MSFT	Stock	27.2	27.2	27.08	27.12	2050.0
2008-08-21 08:30:00	MSFT	Stock	27.2	27.21	27.2	27.21	300.0
2008-08-21 09:00:00	MSFT	Stock	27.2	27.2	27.02	27.03	49559.0
2008-08-21 09:30:00	MSFT	Stock	27.03	27.18	26.91	27.069	4161729.0
2008-08-21 10:00:00	MSFT	Stock	27.06	27.12	27.0	27.04	5116981.0
2008-08-21 10:30:00	MSFT	Stock	27.04	27.05	26.86	26.95	5089630.0
2008-08-21 11:00:00	MSFT	Stock	26.95	27.02	26.9	27.01	3741010.0
2008-08-21 11:30:00	MSFT	Stock	27.002	27.09	26.93	27.01	3102407.0
2008-08-21 12:00:00	MSFT	Stock	27.0	27.05	27.0	27.0	1913878.0
2008-08-21 12:30:00	MSFT	Stock	27.0	27.05	27.0	27.0	1485476.0
2008-08-21 13:00:00	MSFT	Stock	27.0	27.1	26.99	27.01	2693609.0
2008-08-21 13:30:00	MSFT	Stock	27.01	27.12	27.0	27.02	3336531.0
2008-08-21 14:00:00	MSFT	Stock	27.01	27.12	27.0	27.07	2179714.0
2008-08-21 14:30:00	MSFT	Stock	27.072	27.2	27.06	27.1	1978102.0
2008-08-21 15:00:00	MSFT	Stock	27.105	27.23	27.1	27.182	3344628.0
2008-08-21 15:30:00	MSFT	Stock	27.19	27.23	27.14	27.18	2810429.0
2008-08-21 16:00:00	MSFT	Stock	27.2	27.2	27.035	27.186	1471799.0
2008-08-21 16:30:00	MSFT	Stock	27.18	27.18	27.18	27.18	79300.0
2008-08-21 17:00:00	MSFT	Stock	27.14	27.18	27.14	27.18	33326.0
2008-08-21 19:00:00	MSFT	Stock	27.16	27.16	27.16	27.16	300.0
2008-08-21 07:30:00	NVDA	Stock	0.35	0.35	0.35	0.35	64000.0
2008-08-21 08:30:00	NVDA	Stock	0.35	0.35	0.3485	0.3485	122920.0
2008-08-21 09:00:00	NVDA	Stock	0.35	0.35	0.345	0.3453	372680.0
2008-08-21 09:30:00	NVDA	Stock	0.3458	0.3462	0.3388	0.343	130602320.0

> showing 50 of 67,776 rows — these rows as CSV

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