PREVIEW / etf_30min / 2007-12-18

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-12-18.parquet
  size:    150 KB
  rows:    5,358

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-12-18 04:30:00	SPY	ETF	145.7	145.79	145.7	145.79	4000.0
2007-12-18 05:00:00	SPY	ETF	145.84	145.95	145.84	145.95	1000.0
2007-12-18 05:30:00	SPY	ETF	146.05	146.23	146.05	146.23	8700.0
2007-12-18 06:00:00	SPY	ETF	146.29	146.36	146.28	146.32	28800.0
2007-12-18 06:30:00	SPY	ETF	146.35	146.39	146.21	146.26	94200.0
2007-12-18 07:00:00	SPY	ETF	146.22	146.28	146.14	146.14	256200.0
2007-12-18 07:30:00	SPY	ETF	146.14	146.55	146.14	146.39	801600.0
2007-12-18 08:00:00	SPY	ETF	145.14	146.57	145.14	146.38	2858500.0
2007-12-18 08:30:00	SPY	ETF	146.38	146.5	146.11	146.23	1750936.0
2007-12-18 09:00:00	SPY	ETF	146.22	146.29	146.05	146.1	748900.0
2007-12-18 09:30:00	SPY	ETF	146.1	146.21	145.8	146.04	21182019.0
2007-12-18 10:00:00	SPY	ETF	146.04	146.06	145.39	145.66	15753168.0
2007-12-18 10:30:00	SPY	ETF	145.67	145.77	145.08	145.56	15185059.0
2007-12-18 11:00:00	SPY	ETF	145.56	145.65	145.07	145.08	12550185.0
2007-12-18 11:30:00	SPY	ETF	145.09	145.31	144.27	144.41	20949043.0
2007-12-18 12:00:00	SPY	ETF	144.41	144.6	143.96	144.45	27345027.0
2007-12-18 12:30:00	SPY	ETF	144.44	144.72	144.3	144.54	6532152.0
2007-12-18 13:00:00	SPY	ETF	144.53	145.4	144.31	145.23	12126474.0
2007-12-18 13:30:00	SPY	ETF	145.22	145.76	145.15	145.3	16582167.0
2007-12-18 14:00:00	SPY	ETF	145.31	146.11	145.24	146.05	22730844.0
2007-12-18 14:30:00	SPY	ETF	146.05	146.32	145.7	145.8	23845997.0
2007-12-18 15:00:00	SPY	ETF	145.8	146.2	145.72	145.987	15265060.0
2007-12-18 15:30:00	SPY	ETF	145.98	146.48	145.71	145.82	19757291.0
2007-12-18 16:00:00	SPY	ETF	145.81	148.0684	145.64	145.99	4362800.0
2007-12-18 16:30:00	SPY	ETF	146.0	146.27	145.96	146.15	1264400.0
2007-12-18 17:00:00	SPY	ETF	146.15	146.21	145.6016	146.15	188200.0
2007-12-18 17:30:00	SPY	ETF	146.17	146.17	145.78	146.12	2800.0
2007-12-18 18:00:00	SPY	ETF	146.16	146.28	146.16	146.25	7900.0
2007-12-18 18:30:00	SPY	ETF	146.19	146.29	146.19	146.29	3200.0
2007-12-18 19:00:00	SPY	ETF	146.23	146.28	146.23	146.28	5000.0
2007-12-18 19:30:00	SPY	ETF	146.25	146.29	146.17	146.17	3400.0
2007-12-18 05:00:00	QQQ	ETF	50.08	50.08	50.08	50.08	100.0
2007-12-18 05:30:00	QQQ	ETF	50.15	50.15	50.15	50.15	200.0
2007-12-18 06:00:00	QQQ	ETF	50.21	50.26	50.21	50.26	2800.0
2007-12-18 06:30:00	QQQ	ETF	50.24	50.24	50.24	50.24	100.0
2007-12-18 07:00:00	QQQ	ETF	50.2	50.26	50.13	50.16	127654.0
2007-12-18 07:30:00	QQQ	ETF	50.15	50.29	50.15	50.21	138566.0
2007-12-18 08:00:00	QQQ	ETF	50.24	50.33	50.13	50.3	947365.0
2007-12-18 08:30:00	QQQ	ETF	50.3	50.35	50.22	50.24	1263883.0
2007-12-18 09:00:00	QQQ	ETF	50.22	50.37	50.22	50.24	608734.0
2007-12-18 09:30:00	QQQ	ETF	50.24	50.26	49.94	50.09	13872909.0
2007-12-18 10:00:00	QQQ	ETF	50.09	50.1	49.75	49.99	13715501.0
2007-12-18 10:30:00	QQQ	ETF	49.99	50.04	49.72	49.9	10470467.0
2007-12-18 11:00:00	QQQ	ETF	49.89	49.95	49.69	49.71	8417690.0
2007-12-18 11:30:00	QQQ	ETF	49.71	49.79	49.32	49.355	12677727.0
2007-12-18 12:00:00	QQQ	ETF	49.355	49.48	49.18	49.45	12266655.0
2007-12-18 12:30:00	QQQ	ETF	49.44	49.57	49.32	49.51	6852663.0
2007-12-18 13:00:00	QQQ	ETF	49.51	49.95	49.44	49.84	10899331.0
2007-12-18 13:30:00	QQQ	ETF	49.83	50.1	49.76	49.97	16002440.0
2007-12-18 14:00:00	QQQ	ETF	49.97	50.23	49.93	50.19	14524070.0

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

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