PREVIEW / stock_30min / 2009-07-01

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-07-01.parquet
  size:    1.3 MB
  rows:    70,402
  symbols: 3,306

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-07-01 07:00:00	AAPL	Stock	5.1071	5.1114	5.1071	5.1114	22400.0
2009-07-01 07:30:00	AAPL	Stock	5.1118	5.1161	5.1118	5.1161	12600.0
2009-07-01 08:00:00	AAPL	Stock	5.1086	5.1161	5.0868	5.1068	602000.0
2009-07-01 08:30:00	AAPL	Stock	5.1107	5.1125	5.0868	5.1029	1078476.0
2009-07-01 09:00:00	AAPL	Stock	5.1046	5.1289	5.1046	5.1286	1325184.0
2009-07-01 09:30:00	AAPL	Stock	5.1246	5.1489	5.0989	5.1475	76721652.0
2009-07-01 10:00:00	AAPL	Stock	5.1464	5.1643	5.1318	5.1643	64250508.0
2009-07-01 10:30:00	AAPL	Stock	5.1636	5.1664	5.1439	5.1518	29414364.0
2009-07-01 11:00:00	AAPL	Stock	5.1516	5.1554	5.1321	5.1396	23389464.0
2009-07-01 11:30:00	AAPL	Stock	5.1386	5.1571	5.1386	5.1464	21397488.0
2009-07-01 12:00:00	AAPL	Stock	5.1464	5.1504	5.1386	5.1464	15583064.0
2009-07-01 12:30:00	AAPL	Stock	5.1464	5.1486	5.135	5.1357	10031056.0
2009-07-01 13:00:00	AAPL	Stock	5.1361	5.1414	5.1346	5.1407	16660112.0
2009-07-01 13:30:00	AAPL	Stock	5.14	5.1418	5.1304	5.1329	11688936.0
2009-07-01 14:00:00	AAPL	Stock	5.1336	5.1354	5.11	5.1136	27302100.0
2009-07-01 14:30:00	AAPL	Stock	5.1139	5.1175	5.1021	5.1068	25571868.0
2009-07-01 15:00:00	AAPL	Stock	5.1061	5.1179	5.1021	5.1046	29343776.0
2009-07-01 15:30:00	AAPL	Stock	5.1046	5.1107	5.09	5.1011	43731268.0
2009-07-01 16:00:00	AAPL	Stock	5.1011	5.1489	5.0946	5.1036	10099684.0
2009-07-01 16:30:00	AAPL	Stock	5.1018	5.1057	5.1	5.1018	154028.0
2009-07-01 17:00:00	AAPL	Stock	5.1018	5.1111	5.1018	5.1111	40796.0
2009-07-01 17:30:00	AAPL	Stock	5.1075	5.1075	5.1043	5.1043	79352.0
2009-07-01 18:00:00	AAPL	Stock	5.1011	5.1136	5.1011	5.1136	187152.0
2009-07-01 18:30:00	AAPL	Stock	5.1096	5.1096	5.1096	5.1096	8344.0
2009-07-01 19:00:00	AAPL	Stock	5.1121	5.1125	5.1054	5.1054	19600.0
2009-07-01 19:30:00	AAPL	Stock	5.1089	5.11	5.1071	5.11	42308.0
2009-07-01 07:00:00	MSFT	Stock	23.9	23.95	23.9	23.9	3900.0
2009-07-01 07:30:00	MSFT	Stock	23.91	23.91	23.91	23.91	500.0
2009-07-01 08:00:00	MSFT	Stock	23.92	23.95	23.88	23.88	9486.0
2009-07-01 08:30:00	MSFT	Stock	23.92	23.95	23.77	23.92	17653.0
2009-07-01 09:00:00	MSFT	Stock	23.93	24.08	23.93	24.08	83142.0
2009-07-01 09:30:00	MSFT	Stock	24.05	24.22	24.04	24.151	7015311.0
2009-07-01 10:00:00	MSFT	Stock	24.15	24.24	24.0	24.24	6476597.0
2009-07-01 10:30:00	MSFT	Stock	24.24	24.3	24.17	24.19	4619254.0
2009-07-01 11:00:00	MSFT	Stock	24.195	24.21	24.1	24.12	4562255.0
2009-07-01 11:30:00	MSFT	Stock	24.12	24.17	24.09	24.111	2508392.0
2009-07-01 12:00:00	MSFT	Stock	24.12	24.15	24.07	24.08	2143456.0
2009-07-01 12:30:00	MSFT	Stock	24.07	24.08	23.99	23.992	2482190.0
2009-07-01 13:00:00	MSFT	Stock	24.0	24.04	23.96	24.03	2501732.0
2009-07-01 13:30:00	MSFT	Stock	24.039	24.1	23.99	24.08	1527825.0
2009-07-01 14:00:00	MSFT	Stock	24.07	24.13	24.02	24.13	3659685.0
2009-07-01 14:30:00	MSFT	Stock	24.128	24.16	24.08	24.11	3114178.0
2009-07-01 15:00:00	MSFT	Stock	24.11	24.15	24.07	24.09	3369279.0
2009-07-01 15:30:00	MSFT	Stock	24.09	24.1	23.99	24.03	6461510.0
2009-07-01 16:00:00	MSFT	Stock	24.03	24.104	24.0	24.05	2970312.0
2009-07-01 16:30:00	MSFT	Stock	24.01	24.01	24.01	24.01	200.0
2009-07-01 17:00:00	MSFT	Stock	24.03	24.03	23.999	24.03	11039.0
2009-07-01 17:30:00	MSFT	Stock	23.77	24.05	23.77	24.03	6950.0
2009-07-01 18:00:00	MSFT	Stock	24.04	24.04	24.03	24.03	31775.0
2009-07-01 18:30:00	MSFT	Stock	24.04	24.04	24.04	24.04	800.0

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

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