PREVIEW / etf_30min / 2009-10-23

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-10-23.parquet
  size:    235 KB
  rows:    7,649

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-10-23 04:00:00	SPY	ETF	109.81	109.81	109.81	109.81	900.0
2009-10-23 04:30:00	SPY	ETF	109.59	109.68	109.53	109.68	1120.0
2009-10-23 05:00:00	SPY	ETF	109.49	109.49	109.43	109.43	200.0
2009-10-23 05:30:00	SPY	ETF	109.61	109.61	109.61	109.61	300.0
2009-10-23 06:00:00	SPY	ETF	109.58	109.58	109.44	109.44	2700.0
2009-10-23 06:30:00	SPY	ETF	109.48	109.54	109.45	109.54	7800.0
2009-10-23 07:00:00	SPY	ETF	109.5	109.72	109.45	109.71	111336.0
2009-10-23 07:30:00	SPY	ETF	109.74	109.78	109.61	109.68	153437.0
2009-10-23 08:00:00	SPY	ETF	109.66	109.7	109.58	109.68	277358.0
2009-10-23 08:30:00	SPY	ETF	109.66	109.95	109.66	109.9	3005113.0
2009-10-23 09:00:00	SPY	ETF	109.91	109.98	109.34	109.68	2184903.0
2009-10-23 09:30:00	SPY	ETF	109.69	109.76	109.19	109.41	26704260.0
2009-10-23 10:00:00	SPY	ETF	109.41	109.73	108.78	109.08	27456225.0
2009-10-23 10:30:00	SPY	ETF	109.07	109.08	108.51	108.57	15541223.0
2009-10-23 11:00:00	SPY	ETF	108.57	108.74	108.06	108.26	19973102.0
2009-10-23 11:30:00	SPY	ETF	108.27	108.76	108.17	108.469	11471506.0
2009-10-23 12:00:00	SPY	ETF	108.47	108.64	108.25	108.43	7852418.0
2009-10-23 12:30:00	SPY	ETF	108.44	108.73	108.32	108.47	10494270.0
2009-10-23 13:00:00	SPY	ETF	108.46	108.55	108.14	108.17	8225876.0
2009-10-23 13:30:00	SPY	ETF	108.17	108.17	107.77	108.01	16338369.0
2009-10-23 14:00:00	SPY	ETF	108.01	108.28	107.76	108.13	12823316.0
2009-10-23 14:30:00	SPY	ETF	108.13	108.29	107.89	107.95	11728498.0
2009-10-23 15:00:00	SPY	ETF	107.95	108.21	107.8	107.9683	16208838.0
2009-10-23 15:30:00	SPY	ETF	107.97	108.15	107.63	108.07	34348504.0
2009-10-23 16:00:00	SPY	ETF	108.08	109.49	107.91	108.05	5461657.0
2009-10-23 16:30:00	SPY	ETF	108.05	109.411	108.03	108.1	7646050.0
2009-10-23 17:00:00	SPY	ETF	108.09	108.14	108.03	108.06	30352.0
2009-10-23 17:30:00	SPY	ETF	108.06	108.14	108.05	108.05	14514.0
2009-10-23 18:00:00	SPY	ETF	108.09	108.15	108.0	108.15	55901.0
2009-10-23 18:30:00	SPY	ETF	108.15	108.24	108.07	108.12	36920.0
2009-10-23 19:00:00	SPY	ETF	108.14	108.14	108.12	108.12	3200.0
2009-10-23 19:30:00	SPY	ETF	108.13	108.16	108.12	108.16	11501.0
2009-10-23 05:30:00	QQQ	ETF	43.5	43.5	43.5	43.5	2000.0
2009-10-23 06:00:00	QQQ	ETF	43.47	43.47	43.45	43.45	700.0
2009-10-23 07:00:00	QQQ	ETF	43.48	43.53	43.48	43.53	2700.0
2009-10-23 07:30:00	QQQ	ETF	43.52	43.53	43.48	43.5	42914.0
2009-10-23 08:00:00	QQQ	ETF	43.52	43.52	43.48	43.5	192082.0
2009-10-23 08:30:00	QQQ	ETF	43.5	43.79	43.5	43.78	5641187.0
2009-10-23 09:00:00	QQQ	ETF	43.78	43.79	43.31	43.69	1736264.0
2009-10-23 09:30:00	QQQ	ETF	43.69	43.73	43.48	43.62	13778327.0
2009-10-23 10:00:00	QQQ	ETF	43.62	43.71	43.36	43.52	14031394.0
2009-10-23 10:30:00	QQQ	ETF	43.51	43.525	43.19	43.21	11678795.0
2009-10-23 11:00:00	QQQ	ETF	43.21	43.31	43.11	43.19	12907252.0
2009-10-23 11:30:00	QQQ	ETF	43.18	43.34	43.16	43.29	6687750.0
2009-10-23 12:00:00	QQQ	ETF	43.29	43.36	43.23	43.28	3750214.0
2009-10-23 12:30:00	QQQ	ETF	43.28	43.368	43.23	43.2505	3022253.0
2009-10-23 13:00:00	QQQ	ETF	43.25	43.31	43.17	43.1765	3432024.0
2009-10-23 13:30:00	QQQ	ETF	43.17	43.18	43.0399	43.13	7150103.0
2009-10-23 14:00:00	QQQ	ETF	43.14	43.275	43.04	43.211	6261046.0
2009-10-23 14:30:00	QQQ	ETF	43.21	43.25	43.12	43.15	2820255.0

> showing 50 of 7,649 rows — these rows as CSV

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