PREVIEW / etf_30min / 2007-04-03

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-04-03.parquet
  size:    103 KB
  rows:    3,667

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-04-03 04:00:00	SPY	ETF	142.71	142.71	142.71	142.71	400.0
2007-04-03 05:30:00	SPY	ETF	142.79	142.8	142.79	142.8	6000.0
2007-04-03 07:00:00	SPY	ETF	142.78	142.93	142.7	142.93	63000.0
2007-04-03 07:30:00	SPY	ETF	142.88	142.94	142.88	142.94	192700.0
2007-04-03 08:00:00	SPY	ETF	142.85	142.95	142.85	142.94	1126600.0
2007-04-03 08:30:00	SPY	ETF	142.93	143.1	142.7	142.99	633500.0
2007-04-03 09:00:00	SPY	ETF	142.98	143.0	142.16	142.96	629500.0
2007-04-03 09:30:00	SPY	ETF	142.97	143.07	142.91	142.93	9302301.0
2007-04-03 10:00:00	SPY	ETF	142.94	143.48	142.935	143.29	14268760.0
2007-04-03 10:30:00	SPY	ETF	143.28	143.7	143.265	143.62	9351560.0
2007-04-03 11:00:00	SPY	ETF	143.62	143.69	143.53	143.54	4673845.0
2007-04-03 11:30:00	SPY	ETF	143.54	143.75	143.52	143.7	4588900.0
2007-04-03 12:00:00	SPY	ETF	143.7	143.71	143.58	143.59	1312900.0
2007-04-03 12:30:00	SPY	ETF	143.59	143.7	143.57	143.61	2123790.0
2007-04-03 13:00:00	SPY	ETF	143.61	143.84	143.57	143.83	3351290.0
2007-04-03 13:30:00	SPY	ETF	143.8286	143.98	143.75	143.8	4693800.0
2007-04-03 14:00:00	SPY	ETF	143.79	143.86	143.58	143.67	6184225.0
2007-04-03 14:30:00	SPY	ETF	143.67	143.75	143.6	143.6086	3334640.0
2007-04-03 15:00:00	SPY	ETF	143.61	143.73	143.58	143.6686	3970950.0
2007-04-03 15:30:00	SPY	ETF	143.66	143.75	143.58	143.66	6638047.0
2007-04-03 16:00:00	SPY	ETF	143.65	143.71	143.62	143.69	3802300.0
2007-04-03 16:30:00	SPY	ETF	143.68	143.72	143.64	143.68	318700.0
2007-04-03 17:00:00	SPY	ETF	143.66	143.66	143.64	143.64	7800.0
2007-04-03 17:30:00	SPY	ETF	143.67	143.68	143.67	143.68	1400.0
2007-04-03 18:00:00	SPY	ETF	143.66	143.71	143.66	143.71	42600.0
2007-04-03 18:30:00	SPY	ETF	143.72	143.75	143.72	143.75	39600.0
2007-04-03 19:00:00	SPY	ETF	143.73	143.75	143.72	143.75	4300.0
2007-04-03 19:30:00	SPY	ETF	143.74	143.76	143.7	143.76	9600.0
2007-04-03 04:30:00	QQQ	ETF	43.72	43.72	43.72	43.72	600.0
2007-04-03 05:30:00	QQQ	ETF	43.75	43.79	43.75	43.79	36414.0
2007-04-03 07:00:00	QQQ	ETF	43.73	43.79	43.71	43.79	127000.0
2007-04-03 07:30:00	QQQ	ETF	43.8	43.83	43.79	43.81	166921.0
2007-04-03 08:00:00	QQQ	ETF	43.81	43.85	43.8	43.82	332613.0
2007-04-03 08:30:00	QQQ	ETF	43.83	43.86	43.82	43.82	269733.0
2007-04-03 09:00:00	QQQ	ETF	43.82	43.84	43.81	43.82	614616.0
2007-04-03 09:30:00	QQQ	ETF	43.82	43.94	43.79	43.92	16065600.0
2007-04-03 10:00:00	QQQ	ETF	43.92	44.13	43.92	44.02	17481200.0
2007-04-03 10:30:00	QQQ	ETF	44.02	44.31	44.0	44.25	10928400.0
2007-04-03 11:00:00	QQQ	ETF	44.25	44.31	44.16	44.19	6477400.0
2007-04-03 11:30:00	QQQ	ETF	44.19	44.31	44.19	44.28	3560500.0
2007-04-03 12:00:00	QQQ	ETF	44.28	44.29	44.23	44.23	2557000.0
2007-04-03 12:30:00	QQQ	ETF	44.23	44.28	44.21	44.22	1529500.0
2007-04-03 13:00:00	QQQ	ETF	44.22	44.27	44.2	44.25	7828800.0
2007-04-03 13:30:00	QQQ	ETF	44.25	44.3	44.2	44.22	4416900.0
2007-04-03 14:00:00	QQQ	ETF	44.22	44.26	44.16	44.2	9091400.0
2007-04-03 14:30:00	QQQ	ETF	44.2	44.24	44.18	44.2	3366200.0
2007-04-03 15:00:00	QQQ	ETF	44.2	44.24	44.18	44.2	3309100.0
2007-04-03 15:30:00	QQQ	ETF	44.2	44.25	44.13	44.17	10521900.0
2007-04-03 16:00:00	QQQ	ETF	44.17	44.24	44.14	44.23	3791667.0
2007-04-03 16:30:00	QQQ	ETF	44.21	44.22	44.18	44.2	362917.0

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

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