PREVIEW / etf_30min / 2007-01-24

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-01-24.parquet
  size:    98 KB
  rows:    3,430

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-24 06:30:00	SPY	ETF	143.02	143.05	143.02	143.05	6500.0
2007-01-24 07:00:00	SPY	ETF	143.06	143.09	143.06	143.07	24000.0
2007-01-24 07:30:00	SPY	ETF	143.03	143.03	143.0	143.0	1400.0
2007-01-24 08:00:00	SPY	ETF	143.0	143.08	142.94	143.05	109900.0
2007-01-24 08:30:00	SPY	ETF	143.05	143.11	143.02	143.02	564000.0
2007-01-24 09:00:00	SPY	ETF	143.01	143.09	142.94	142.97	328800.0
2007-01-24 09:30:00	SPY	ETF	142.97	143.2	142.91	143.08	5397500.0
2007-01-24 10:00:00	SPY	ETF	143.07	143.17	142.93	143.06	4557900.0
2007-01-24 10:30:00	SPY	ETF	143.05	143.36	143.02	143.31	4928300.0
2007-01-24 11:00:00	SPY	ETF	143.3	143.52	143.28	143.37	6054500.0
2007-01-24 11:30:00	SPY	ETF	143.37	143.43	143.29	143.33	2841100.0
2007-01-24 12:00:00	SPY	ETF	143.33	143.39	143.28	143.35	1081400.0
2007-01-24 12:30:00	SPY	ETF	143.36	143.47	143.32	143.37	1930500.0
2007-01-24 13:00:00	SPY	ETF	143.37	143.4	143.27	143.38	1717700.0
2007-01-24 13:30:00	SPY	ETF	143.36	143.71	143.3	143.62	4033100.0
2007-01-24 14:00:00	SPY	ETF	143.62	143.66	143.5	143.65	4679100.0
2007-01-24 14:30:00	SPY	ETF	143.65	143.85	143.63	143.72	5239700.0
2007-01-24 15:00:00	SPY	ETF	143.73	143.85	143.69	143.8	3069600.0
2007-01-24 15:30:00	SPY	ETF	143.8	143.98	143.77	143.92	6347100.0
2007-01-24 16:00:00	SPY	ETF	143.93	144.26	143.85	144.08	706200.0
2007-01-24 16:30:00	SPY	ETF	144.04	144.05	143.94	144.02	335100.0
2007-01-24 17:00:00	SPY	ETF	144.02	144.05	144.0	144.02	67900.0
2007-01-24 17:30:00	SPY	ETF	144.06	144.07	144.06	144.07	2000.0
2007-01-24 18:00:00	SPY	ETF	144.0	144.01	142.8	142.8	632100.0
2007-01-24 18:30:00	SPY	ETF	143.97	143.97	143.97	143.97	600.0
2007-01-24 19:00:00	SPY	ETF	143.99	143.99	143.99	143.99	100.0
2007-01-24 19:30:00	SPY	ETF	143.99	143.99	143.99	143.99	300.0
2007-01-24 04:00:00	QQQ	ETF	43.78	43.78	43.78	43.78	200.0
2007-01-24 05:30:00	QQQ	ETF	43.8	43.83	43.8	43.83	1200.0
2007-01-24 06:00:00	QQQ	ETF	43.82	43.82	43.82	43.82	25000.0
2007-01-24 06:30:00	QQQ	ETF	43.84	43.84	43.84	43.84	500.0
2007-01-24 07:00:00	QQQ	ETF	43.83	43.86	43.82	43.82	197521.0
2007-01-24 07:30:00	QQQ	ETF	43.82	43.83	43.79	43.79	166686.0
2007-01-24 08:00:00	QQQ	ETF	43.79	43.86	43.78	43.85	298295.0
2007-01-24 08:30:00	QQQ	ETF	43.85	43.88	43.83	43.83	1248828.0
2007-01-24 09:00:00	QQQ	ETF	43.84	43.88	43.84	43.86	1276045.0
2007-01-24 09:30:00	QQQ	ETF	43.85	44.01	43.77	43.87	19226200.0
2007-01-24 10:00:00	QQQ	ETF	43.87	43.97	43.82	43.92	8855200.0
2007-01-24 10:30:00	QQQ	ETF	43.92	44.18	43.91	44.17	14825300.0
2007-01-24 11:00:00	QQQ	ETF	44.17	44.28	44.14	44.19	14074100.0
2007-01-24 11:30:00	QQQ	ETF	44.19	44.27	44.19	44.21	4717800.0
2007-01-24 12:00:00	QQQ	ETF	44.22	44.27	44.19	44.23	3616000.0
2007-01-24 12:30:00	QQQ	ETF	44.24	44.32	44.2	44.21	5877100.0
2007-01-24 13:00:00	QQQ	ETF	44.21	44.22	44.14	44.18	2498900.0
2007-01-24 13:30:00	QQQ	ETF	44.17	44.3	44.15	44.28	4576800.0
2007-01-24 14:00:00	QQQ	ETF	44.27	44.29	44.2	44.25	2122200.0
2007-01-24 14:30:00	QQQ	ETF	44.25	44.31	44.22	44.24	4729400.0
2007-01-24 15:00:00	QQQ	ETF	44.23	44.29	44.22	44.26	3524100.0
2007-01-24 15:30:00	QQQ	ETF	44.26	44.3	44.22	44.29	8642500.0
2007-01-24 16:00:00	QQQ	ETF	44.3	44.45	44.24	44.41	4315176.0

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

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