PREVIEW / stock_30min / 2009-04-08

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-04-08.parquet
  size:    1.2 MB
  rows:    69,162
  symbols: 3,299

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-08 04:00:00	AAPL	Stock	4.0954	4.0954	4.0579	4.0579	15960.0
2009-04-08 05:30:00	AAPL	Stock	4.0643	4.0704	4.0643	4.0704	14000.0
2009-04-08 06:30:00	AAPL	Stock	4.0786	4.0786	4.0786	4.0786	14000.0
2009-04-08 07:00:00	AAPL	Stock	4.0954	4.1071	4.0954	4.0982	112000.0
2009-04-08 08:00:00	AAPL	Stock	4.0982	4.135	4.0982	4.1321	500248.0
2009-04-08 08:30:00	AAPL	Stock	4.1321	4.1343	4.125	4.1321	499688.0
2009-04-08 09:00:00	AAPL	Stock	4.1325	4.1375	4.1171	4.1171	1285620.0
2009-04-08 09:30:00	AAPL	Stock	4.1225	4.1711	4.1164	4.1575	58502248.0
2009-04-08 10:00:00	AAPL	Stock	4.1575	4.1596	4.0921	4.1054	51995720.0
2009-04-08 10:30:00	AAPL	Stock	4.1061	4.1179	4.0943	4.1129	34016808.0
2009-04-08 11:00:00	AAPL	Stock	4.1121	4.1304	4.1011	4.1196	32501896.0
2009-04-08 11:30:00	AAPL	Stock	4.1196	4.1389	4.1121	4.1136	30018380.0
2009-04-08 12:00:00	AAPL	Stock	4.1136	4.14	4.1093	4.1318	20910792.0
2009-04-08 12:30:00	AAPL	Stock	4.1318	4.1607	4.1207	4.1525	26459608.0
2009-04-08 13:00:00	AAPL	Stock	4.1525	4.1529	4.1327	4.1364	18949140.0
2009-04-08 13:30:00	AAPL	Stock	4.1368	4.1446	4.1321	4.1407	19999140.0
2009-04-08 14:00:00	AAPL	Stock	4.1407	4.1418	4.1218	4.1314	29582308.0
2009-04-08 14:30:00	AAPL	Stock	4.1312	4.1411	4.1211	4.1286	26871180.0
2009-04-08 15:00:00	AAPL	Stock	4.1285	4.1389	4.1118	4.1307	32705120.0
2009-04-08 15:30:00	AAPL	Stock	4.1307	4.1557	4.1271	4.1543	55265112.0
2009-04-08 16:00:00	AAPL	Stock	4.1543	4.1621	4.1175	4.1589	6483120.0
2009-04-08 16:30:00	AAPL	Stock	4.1589	4.1589	4.1316	4.1589	169624.0
2009-04-08 17:00:00	AAPL	Stock	4.1543	4.1607	4.1543	4.1607	33432.0
2009-04-08 17:30:00	AAPL	Stock	4.1607	4.1643	4.1546	4.1546	124236.0
2009-04-08 18:00:00	AAPL	Stock	4.1546	4.1607	4.1543	4.1607	305676.0
2009-04-08 18:30:00	AAPL	Stock	4.1607	4.1664	4.1554	4.1661	116200.0
2009-04-08 19:00:00	AAPL	Stock	4.1686	4.1696	4.1643	4.1696	36400.0
2009-04-08 19:30:00	AAPL	Stock	4.1668	4.1668	4.1575	4.1575	54824.0
2009-04-08 07:00:00	MSFT	Stock	18.91	18.91	18.91	18.91	100.0
2009-04-08 08:00:00	MSFT	Stock	18.77	18.85	18.71	18.85	9332.0
2009-04-08 08:30:00	MSFT	Stock	18.85	18.92	18.85	18.91	13323.0
2009-04-08 09:00:00	MSFT	Stock	18.91	18.98	18.9	18.95	25617.0
2009-04-08 09:30:00	MSFT	Stock	18.95	19.28	18.94	19.27	5260249.0
2009-04-08 10:00:00	MSFT	Stock	19.27	19.31	19.06	19.108	3890084.0
2009-04-08 10:30:00	MSFT	Stock	19.11	19.19	19.02	19.09	2935011.0
2009-04-08 11:00:00	MSFT	Stock	19.09	19.43	19.068	19.382	6167349.0
2009-04-08 11:30:00	MSFT	Stock	19.38	19.47	19.35	19.41	4164739.0
2009-04-08 12:00:00	MSFT	Stock	19.415	19.44	19.29	19.375	3873291.0
2009-04-08 12:30:00	MSFT	Stock	19.38	19.62	19.36	19.58	4963377.0
2009-04-08 13:00:00	MSFT	Stock	19.58	19.59	19.45	19.49	2134471.0
2009-04-08 13:30:00	MSFT	Stock	19.49	19.52	19.4	19.415	2487016.0
2009-04-08 14:00:00	MSFT	Stock	19.416	19.42	19.22	19.29	3218157.0
2009-04-08 14:30:00	MSFT	Stock	19.289	19.36	19.21	19.24	3723425.0
2009-04-08 15:00:00	MSFT	Stock	19.25	19.25	19.15	19.15	3719853.0
2009-04-08 15:30:00	MSFT	Stock	19.15	19.26	19.14	19.2	7080455.0
2009-04-08 16:00:00	MSFT	Stock	19.2	19.44	19.15	19.19	1789697.0
2009-04-08 16:30:00	MSFT	Stock	19.21	19.22	19.19	19.22	36243.0
2009-04-08 17:00:00	MSFT	Stock	19.19	19.27	19.19	19.23	8663.0
2009-04-08 17:30:00	MSFT	Stock	19.25	19.25	19.22	19.22	700.0
2009-04-08 18:00:00	MSFT	Stock	19.22	19.25	19.16	19.16	172568.0

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

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