PREVIEW / stock_30min / 2009-04-03

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-04-03.parquet
  size:    1.2 MB
  rows:    68,251
  symbols: 3,331

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-03 06:30:00	AAPL	Stock	4.1032	4.1246	4.1032	4.1246	34552.0
2009-04-03 07:00:00	AAPL	Stock	4.1079	4.1268	4.1079	4.1268	158032.0
2009-04-03 07:30:00	AAPL	Stock	4.125	4.1382	4.1171	4.125	221172.0
2009-04-03 08:00:00	AAPL	Stock	4.1171	4.125	4.0	4.1068	982464.0
2009-04-03 08:30:00	AAPL	Stock	4.1068	4.125	4.0821	4.0871	1538124.0
2009-04-03 09:00:00	AAPL	Stock	4.0871	4.0982	4.0632	4.0825	1645140.0
2009-04-03 09:30:00	AAPL	Stock	4.0825	4.1157	4.0543	4.0943	88512760.0
2009-04-03 10:00:00	AAPL	Stock	4.0925	4.11	4.0679	4.1046	58184336.0
2009-04-03 10:30:00	AAPL	Stock	4.1054	4.1232	4.0843	4.1156	44207884.0
2009-04-03 11:00:00	AAPL	Stock	4.1157	4.1275	4.0696	4.1104	41408248.0
2009-04-03 11:30:00	AAPL	Stock	4.1107	4.1464	4.1107	4.1429	39958464.0
2009-04-03 12:00:00	AAPL	Stock	4.1429	4.1475	4.1225	4.1379	38638012.0
2009-04-03 12:30:00	AAPL	Stock	4.1379	4.14	4.1089	4.1204	29930432.0
2009-04-03 13:00:00	AAPL	Stock	4.1211	4.1429	4.1179	4.1425	30729944.0
2009-04-03 13:30:00	AAPL	Stock	4.1421	4.1446	4.12	4.1381	33614336.0
2009-04-03 14:00:00	AAPL	Stock	4.1392	4.1425	4.1246	4.1414	30964136.0
2009-04-03 14:30:00	AAPL	Stock	4.1418	4.1421	4.1254	4.1379	35186368.0
2009-04-03 15:00:00	AAPL	Stock	4.1375	4.1393	4.1139	4.1186	47830300.0
2009-04-03 15:30:00	AAPL	Stock	4.1182	4.1436	4.1114	4.1421	66769332.0
2009-04-03 16:00:00	AAPL	Stock	4.1421	4.1511	4.1162	4.1425	11306204.0
2009-04-03 16:30:00	AAPL	Stock	4.1429	4.1457	4.1404	4.1454	215544.0
2009-04-03 17:00:00	AAPL	Stock	4.1457	4.1482	4.1425	4.1471	459200.0
2009-04-03 17:30:00	AAPL	Stock	4.145	4.1471	4.145	4.1471	20720.0
2009-04-03 18:00:00	AAPL	Stock	4.1464	4.1482	4.1425	4.145	3031000.0
2009-04-03 18:30:00	AAPL	Stock	4.145	4.1457	4.145	4.1457	25200.0
2009-04-03 19:00:00	AAPL	Stock	4.1457	4.1471	4.1457	4.1461	44044.0
2009-04-03 19:30:00	AAPL	Stock	4.1446	4.1464	4.1446	4.1464	22400.0
2009-04-03 07:30:00	MSFT	Stock	19.4	19.4	19.31	19.31	1900.0
2009-04-03 08:00:00	MSFT	Stock	19.31	19.35	19.25	19.35	14635.0
2009-04-03 08:30:00	MSFT	Stock	19.38	19.4	19.01	19.08	33563.0
2009-04-03 09:00:00	MSFT	Stock	19.1	19.17	18.92	19.17	39962.0
2009-04-03 09:30:00	MSFT	Stock	19.13	19.15	18.7	18.75	9623129.0
2009-04-03 10:00:00	MSFT	Stock	18.75	18.77	18.61	18.62	7988683.0
2009-04-03 10:30:00	MSFT	Stock	18.619	18.65	18.5	18.56	6555304.0
2009-04-03 11:00:00	MSFT	Stock	18.56	18.62	18.434	18.6	6908892.0
2009-04-03 11:30:00	MSFT	Stock	18.6	18.72	18.59	18.659	4014495.0
2009-04-03 12:00:00	MSFT	Stock	18.66	18.88	18.65	18.81	5780973.0
2009-04-03 12:30:00	MSFT	Stock	18.82	18.862	18.72	18.75	3245381.0
2009-04-03 13:00:00	MSFT	Stock	18.74	18.81	18.65	18.732	3872000.0
2009-04-03 13:30:00	MSFT	Stock	18.74	18.79	18.7	18.77	2619831.0
2009-04-03 14:00:00	MSFT	Stock	18.78	18.81	18.68	18.8	3177935.0
2009-04-03 14:30:00	MSFT	Stock	18.8	18.82	18.7	18.78	4437630.0
2009-04-03 15:00:00	MSFT	Stock	18.79	18.79	18.56	18.57	6520561.0
2009-04-03 15:30:00	MSFT	Stock	18.57	18.84	18.51	18.84	10932319.0
2009-04-03 16:00:00	MSFT	Stock	18.74	18.8	18.644	18.75	2599061.0
2009-04-03 16:30:00	MSFT	Stock	18.74	18.74	18.7	18.7	39753.0
2009-04-03 17:00:00	MSFT	Stock	18.72	18.73	18.72	18.73	5938.0
2009-04-03 17:30:00	MSFT	Stock	18.57	18.74	18.57	18.73	16234.0
2009-04-03 18:00:00	MSFT	Stock	18.74	18.75	18.73	18.74	429909.0
2009-04-03 18:30:00	MSFT	Stock	18.74	18.74	18.72	18.72	1600.0

> showing 50 of 68,251 rows — these rows as CSV

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