PREVIEW / etf_30min / 2007-11-20

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-11-20.parquet
  size:    150 KB
  rows:    5,351

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
2007-11-20 04:00:00	SPY	ETF	144.34	144.34	144.34	144.34	1000.0
2007-11-20 04:30:00	SPY	ETF	144.54	144.66	144.49	144.66	4000.0
2007-11-20 05:00:00	SPY	ETF	144.59	144.69	144.58	144.69	6500.0
2007-11-20 05:30:00	SPY	ETF	144.74	144.79	144.72	144.72	3500.0
2007-11-20 06:00:00	SPY	ETF	144.61	144.7	144.6	144.62	31500.0
2007-11-20 06:30:00	SPY	ETF	144.82	145.0	144.82	144.87	34800.0
2007-11-20 07:00:00	SPY	ETF	144.86	144.87	144.68	144.82	798900.0
2007-11-20 07:30:00	SPY	ETF	144.8	144.8	144.12	144.37	1419600.0
2007-11-20 08:00:00	SPY	ETF	144.35	144.86	144.2	144.32	1642100.0
2007-11-20 08:30:00	SPY	ETF	144.32	144.78	143.74	143.95	7204200.0
2007-11-20 09:00:00	SPY	ETF	143.97	144.14	143.6	143.63	3811700.0
2007-11-20 09:30:00	SPY	ETF	143.64	144.96	143.61	144.81	44206145.0
2007-11-20 10:00:00	SPY	ETF	144.8	145.24	144.64	144.84	33187264.0
2007-11-20 10:30:00	SPY	ETF	144.84	145.51	144.65	145.29	24550233.0
2007-11-20 11:00:00	SPY	ETF	145.29	145.53	144.92	145.08	14048221.0
2007-11-20 11:30:00	SPY	ETF	145.08	145.19	144.68	144.71	10548661.0
2007-11-20 12:00:00	SPY	ETF	144.72	144.73	143.99	144.21	19065414.0
2007-11-20 12:30:00	SPY	ETF	144.21	144.24	143.52	143.84	20272520.0
2007-11-20 13:00:00	SPY	ETF	143.85	143.85	142.62	142.76	29760394.0
2007-11-20 13:30:00	SPY	ETF	142.75	144.13	142.71	143.39	13332255.0
2007-11-20 14:00:00	SPY	ETF	143.39	145.1	142.18	142.29	46650919.0
2007-11-20 14:30:00	SPY	ETF	142.28	145.46	142.11	142.65	42447446.0
2007-11-20 15:00:00	SPY	ETF	142.65	143.56	142.31	143.37	27788663.0
2007-11-20 15:30:00	SPY	ETF	143.37	144.86	143.33	144.2	59004841.0
2007-11-20 16:00:00	SPY	ETF	144.25	144.86	143.01	144.6	5425700.0
2007-11-20 16:30:00	SPY	ETF	144.58	144.84	143.5475	144.45	4378600.0
2007-11-20 17:00:00	SPY	ETF	144.46	144.47	144.4	144.45	236700.0
2007-11-20 17:30:00	SPY	ETF	144.45	144.46	144.4	144.46	22000.0
2007-11-20 18:00:00	SPY	ETF	144.46	144.47	144.17	144.35	459100.0
2007-11-20 18:30:00	SPY	ETF	144.33	144.45	144.33	144.4	26600.0
2007-11-20 19:00:00	SPY	ETF	144.34	144.34	144.01	144.11	12900.0
2007-11-20 19:30:00	SPY	ETF	144.15	144.15	144.03	144.09	17600.0
2007-11-20 04:00:00	QQQ	ETF	49.97	49.97	49.97	49.97	5000.0
2007-11-20 04:30:00	QQQ	ETF	50.02	50.04	50.02	50.04	5000.0
2007-11-20 06:00:00	QQQ	ETF	50.05	50.05	50.01	50.03	8700.0
2007-11-20 06:30:00	QQQ	ETF	50.15	50.18	50.13	50.18	11100.0
2007-11-20 07:00:00	QQQ	ETF	50.16	50.29	50.11	50.26	443157.0
2007-11-20 07:30:00	QQQ	ETF	50.29	50.31	50.13	50.16	869317.0
2007-11-20 08:00:00	QQQ	ETF	50.15	50.2	50.09	50.15	1929157.0
2007-11-20 08:30:00	QQQ	ETF	50.16	50.22	49.97	50.04	3797168.0
2007-11-20 09:00:00	QQQ	ETF	50.04	50.11	49.94	49.96	1206103.0
2007-11-20 09:30:00	QQQ	ETF	49.96	50.43	49.92	50.35	17267064.0
2007-11-20 10:00:00	QQQ	ETF	50.36	50.56	50.25	50.38	22812559.0
2007-11-20 10:30:00	QQQ	ETF	50.37	50.75	50.29	50.69	14564260.0
2007-11-20 11:00:00	QQQ	ETF	50.69	50.78	50.51	50.58	20386570.0
2007-11-20 11:30:00	QQQ	ETF	50.59	50.66	50.41	50.44	7624244.0
2007-11-20 12:00:00	QQQ	ETF	50.44	50.45	50.14	50.17	19433501.0
2007-11-20 12:30:00	QQQ	ETF	50.17	50.2	49.84	49.95	16677753.0
2007-11-20 13:00:00	QQQ	ETF	49.94	50.06	49.4	49.44	24542863.0
2007-11-20 13:30:00	QQQ	ETF	49.44	49.9	49.42	49.81	14393181.0

> showing 50 of 5,351 rows — these rows as CSV

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