PREVIEW / etf_30min / 2007-01-17

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-01-17.parquet
  size:    95 KB
  rows:    3,383

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-01-17 05:30:00	SPY	ETF	143.05	143.05	143.04	143.04	10000.0
2007-01-17 07:00:00	SPY	ETF	143.1	143.22	143.1	143.22	5600.0
2007-01-17 07:30:00	SPY	ETF	143.22	143.22	143.12	143.12	1300.0
2007-01-17 08:00:00	SPY	ETF	143.13	143.18	143.1	143.14	116500.0
2007-01-17 08:30:00	SPY	ETF	143.1	143.11	142.71	142.75	1150800.0
2007-01-17 09:00:00	SPY	ETF	142.73	142.9	142.73	142.88	257600.0
2007-01-17 09:30:00	SPY	ETF	142.85	143.16	142.79	143.08	6444500.0
2007-01-17 10:00:00	SPY	ETF	143.08	143.08	142.8	142.95	3716900.0
2007-01-17 10:30:00	SPY	ETF	142.95	143.05	142.75	142.95	3183600.0
2007-01-17 11:00:00	SPY	ETF	142.97	143.21	142.95	143.06	2244000.0
2007-01-17 11:30:00	SPY	ETF	143.07	143.29	142.99	143.24	2260100.0
2007-01-17 12:00:00	SPY	ETF	143.23	143.43	143.22	143.35	3780300.0
2007-01-17 12:30:00	SPY	ETF	143.35	143.39	143.29	143.35	1471800.0
2007-01-17 13:00:00	SPY	ETF	143.36	143.4	143.2	143.24	1439100.0
2007-01-17 13:30:00	SPY	ETF	143.24	143.32	143.17	143.27	2083400.0
2007-01-17 14:00:00	SPY	ETF	143.26	143.46	142.99	143.13	4443100.0
2007-01-17 14:30:00	SPY	ETF	143.13	143.16	142.83	143.05	4114500.0
2007-01-17 15:00:00	SPY	ETF	143.06	143.06	142.73	142.88	4225900.0
2007-01-17 15:30:00	SPY	ETF	142.87	143.01	142.87	143.0	3308100.0
2007-01-17 16:00:00	SPY	ETF	143.03	143.1	142.94	143.04	751800.0
2007-01-17 16:30:00	SPY	ETF	143.02	143.14	142.92	143.01	1061600.0
2007-01-17 17:00:00	SPY	ETF	142.98	143.01	142.89	142.89	107800.0
2007-01-17 17:30:00	SPY	ETF	142.87	142.88	142.81	142.87	13100.0
2007-01-17 18:00:00	SPY	ETF	142.9	142.92	142.85	142.87	1362400.0
2007-01-17 19:00:00	SPY	ETF	142.9	142.9	142.87	142.87	900.0
2007-01-17 19:30:00	SPY	ETF	142.9	142.93	142.9	142.93	600.0
2007-01-17 07:00:00	QQQ	ETF	45.17	45.2	45.17	45.18	6600.0
2007-01-17 07:30:00	QQQ	ETF	45.17	45.18	45.17	45.18	8600.0
2007-01-17 08:00:00	QQQ	ETF	45.19	45.21	45.18	45.2	82190.0
2007-01-17 08:30:00	QQQ	ETF	45.2	45.2	45.05	45.06	1099573.0
2007-01-17 09:00:00	QQQ	ETF	45.07	45.13	45.06	45.09	789306.0
2007-01-17 09:30:00	QQQ	ETF	45.09	45.27	45.07	45.18	21019900.0
2007-01-17 10:00:00	QQQ	ETF	45.17	45.18	45.08	45.13	9955900.0
2007-01-17 10:30:00	QQQ	ETF	45.13	45.2	45.05	45.17	7761900.0
2007-01-17 11:00:00	QQQ	ETF	45.17	45.24	45.09	45.15	6970400.0
2007-01-17 11:30:00	QQQ	ETF	45.16	45.21	45.11	45.18	4821500.0
2007-01-17 12:00:00	QQQ	ETF	45.18	45.29	45.12	45.2	6433000.0
2007-01-17 12:30:00	QQQ	ETF	45.21	45.21	45.15	45.2	1790000.0
2007-01-17 13:00:00	QQQ	ETF	45.2	45.21	45.12	45.13	4120400.0
2007-01-17 13:30:00	QQQ	ETF	45.13	45.19	45.1	45.14	2637300.0
2007-01-17 14:00:00	QQQ	ETF	45.13	45.21	44.96	45.03	9076700.0
2007-01-17 14:30:00	QQQ	ETF	45.02	45.19	44.9	44.97	9092600.0
2007-01-17 15:00:00	QQQ	ETF	44.96	44.97	44.83	44.96	9552100.0
2007-01-17 15:30:00	QQQ	ETF	44.95	45.19	44.88	44.9	8101200.0
2007-01-17 16:00:00	QQQ	ETF	44.91	44.97	44.8	44.92	3355724.0
2007-01-17 16:30:00	QQQ	ETF	44.92	45.04	44.82	44.96	6341165.0
2007-01-17 17:00:00	QQQ	ETF	44.96	44.98	44.77	44.77	1291902.0
2007-01-17 17:30:00	QQQ	ETF	44.77	44.9	44.75	44.8	562253.0
2007-01-17 18:00:00	QQQ	ETF	44.82	44.82	44.74	44.79	393976.0
2007-01-17 18:30:00	QQQ	ETF	44.79	44.8	44.76	44.78	30913.0

> showing 50 of 3,383 rows — these rows as CSV

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