PREVIEW / stock_30min / 2009-04-07

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-04-07.parquet
  size:    1.3 MB
  rows:    70,986
  symbols: 3,301

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
2009-04-07 05:00:00	AAPL	Stock	4.1607	4.1607	4.1607	4.1607	3584.0
2009-04-07 05:30:00	AAPL	Stock	4.1429	4.1429	4.1429	4.1429	10864.0
2009-04-07 06:30:00	AAPL	Stock	4.1804	4.1804	4.1793	4.1793	5600.0
2009-04-07 07:00:00	AAPL	Stock	4.1607	4.1607	4.1475	4.1475	44800.0
2009-04-07 07:30:00	AAPL	Stock	4.1586	4.1743	4.1586	4.1625	46060.0
2009-04-07 08:00:00	AAPL	Stock	4.1589	4.1721	4.1536	4.1643	576240.0
2009-04-07 08:30:00	AAPL	Stock	4.1614	4.1657	4.1546	4.1646	337120.0
2009-04-07 09:00:00	AAPL	Stock	4.1671	4.1714	4.1536	4.1593	1494584.0
2009-04-07 09:30:00	AAPL	Stock	4.1607	4.1668	4.1236	4.1296	72413040.0
2009-04-07 10:00:00	AAPL	Stock	4.1293	4.1364	4.0936	4.1325	63267680.0
2009-04-07 10:30:00	AAPL	Stock	4.1325	4.1496	4.1179	4.1307	47469660.0
2009-04-07 11:00:00	AAPL	Stock	4.1311	4.1371	4.1146	4.1211	23461368.0
2009-04-07 11:30:00	AAPL	Stock	4.1204	4.1307	4.1054	4.1096	28400652.0
2009-04-07 12:00:00	AAPL	Stock	4.1096	4.1304	4.1014	4.1161	30481248.0
2009-04-07 12:30:00	AAPL	Stock	4.1161	4.1282	4.1071	4.1209	20467468.0
2009-04-07 13:00:00	AAPL	Stock	4.1218	4.1218	4.0839	4.09	35735840.0
2009-04-07 13:30:00	AAPL	Stock	4.0896	4.0996	4.0782	4.0932	27509944.0
2009-04-07 14:00:00	AAPL	Stock	4.0931	4.0964	4.0782	4.0876	21829276.0
2009-04-07 14:30:00	AAPL	Stock	4.0879	4.0964	4.0796	4.0932	22469300.0
2009-04-07 15:00:00	AAPL	Stock	4.0932	4.1189	4.0804	4.1029	44449300.0
2009-04-07 15:30:00	AAPL	Stock	4.1025	4.1346	4.0975	4.0989	71331428.0
2009-04-07 16:00:00	AAPL	Stock	4.1071	4.1161	4.0986	4.1159	18153548.0
2009-04-07 16:30:00	AAPL	Stock	4.1071	4.12	4.1071	4.1136	334852.0
2009-04-07 17:00:00	AAPL	Stock	4.1121	4.225	4.1071	4.1093	505540.0
2009-04-07 17:30:00	AAPL	Stock	4.1124	4.1124	4.1071	4.1071	141512.0
2009-04-07 18:00:00	AAPL	Stock	4.1071	4.1107	4.105	4.1107	971292.0
2009-04-07 18:30:00	AAPL	Stock	4.1071	4.1125	4.1054	4.1054	55356.0
2009-04-07 19:00:00	AAPL	Stock	4.1054	4.1082	4.105	4.1082	26012.0
2009-04-07 19:30:00	AAPL	Stock	4.1107	4.1107	4.1071	4.1071	62160.0
2009-04-07 04:30:00	MSFT	Stock	18.82	18.86	18.8	18.83	4625.0
2009-04-07 05:00:00	MSFT	Stock	18.83	18.83	18.72	18.72	600.0
2009-04-07 05:30:00	MSFT	Stock	18.7	18.7	18.7	18.7	100.0
2009-04-07 06:30:00	MSFT	Stock	18.62	18.65	18.62	18.65	2100.0
2009-04-07 07:30:00	MSFT	Stock	18.52	18.52	18.52	18.52	200.0
2009-04-07 08:00:00	MSFT	Stock	18.65	18.67	18.52	18.61	7380.0
2009-04-07 08:30:00	MSFT	Stock	18.64	18.65	18.59	18.63	9805.0
2009-04-07 09:00:00	MSFT	Stock	18.63	19.5	18.63	18.76	95174.0
2009-04-07 09:30:00	MSFT	Stock	18.77	19.14	18.75	19.09	11410496.0
2009-04-07 10:00:00	MSFT	Stock	19.092	19.1	18.98	19.07	5042657.0
2009-04-07 10:30:00	MSFT	Stock	19.052	19.08	18.96	19.03	5093905.0
2009-04-07 11:00:00	MSFT	Stock	19.03	19.05	18.99	19.03	2316178.0
2009-04-07 11:30:00	MSFT	Stock	19.02	19.06	18.97	19.01	3410975.0
2009-04-07 12:00:00	MSFT	Stock	19.01	19.05	18.98	19.01	3191301.0
2009-04-07 12:30:00	MSFT	Stock	19.0	19.02	18.91	18.98	2317688.0
2009-04-07 13:00:00	MSFT	Stock	18.98	18.99	18.82	18.828	4424387.0
2009-04-07 13:30:00	MSFT	Stock	18.82	18.83	18.7	18.76	3974199.0
2009-04-07 14:00:00	MSFT	Stock	18.762	18.765	18.65	18.69	2927168.0
2009-04-07 14:30:00	MSFT	Stock	18.7	18.77	18.63	18.77	3288536.0
2009-04-07 15:00:00	MSFT	Stock	18.765	18.82	18.7	18.75	4761445.0
2009-04-07 15:30:00	MSFT	Stock	18.74	18.941	18.71	18.71	9765597.0

> showing 50 of 70,986 rows — these rows as CSV

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