PREVIEW / etf_30min / 2007-09-17

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-09-17.parquet
  size:    121 KB
  rows:    4,562

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-09-17 04:00:00	SPY	ETF	148.02	148.04	148.0	148.04	4100.0
2007-09-17 04:30:00	SPY	ETF	147.99	147.99	147.92	147.92	16000.0
2007-09-17 05:00:00	SPY	ETF	147.87	147.89	147.87	147.89	800.0
2007-09-17 05:30:00	SPY	ETF	147.86	147.89	147.82	147.82	8300.0
2007-09-17 06:00:00	SPY	ETF	147.91	147.91	147.9	147.9	3000.0
2007-09-17 06:30:00	SPY	ETF	147.97	148.05	147.9	147.9	81700.0
2007-09-17 07:00:00	SPY	ETF	147.94	148.1	147.89	147.92	321900.0
2007-09-17 07:30:00	SPY	ETF	147.98	148.11	147.9	148.07	507300.0
2007-09-17 08:00:00	SPY	ETF	148.07	148.31	147.91	148.11	1247800.0
2007-09-17 08:30:00	SPY	ETF	148.1	148.31	147.82	148.26	810400.0
2007-09-17 09:00:00	SPY	ETF	148.25	148.39	148.22	148.28	509100.0
2007-09-17 09:30:00	SPY	ETF	148.31	148.54	148.23	148.37	16215375.0
2007-09-17 10:00:00	SPY	ETF	148.36	148.65	148.3	148.32	6682900.0
2007-09-17 10:30:00	SPY	ETF	148.32	148.45	147.88	148.0	12025300.0
2007-09-17 11:00:00	SPY	ETF	148.0	148.19	147.91	147.95	5472600.0
2007-09-17 11:30:00	SPY	ETF	147.94	147.97	147.69	147.82	7888700.0
2007-09-17 12:00:00	SPY	ETF	147.82	147.94	147.63	147.92	3654600.0
2007-09-17 12:30:00	SPY	ETF	147.93	148.29	147.9	148.28	6563300.0
2007-09-17 13:00:00	SPY	ETF	148.28	148.8905	148.18	148.22	6410300.0
2007-09-17 13:30:00	SPY	ETF	148.23	148.28	148.0	148.02	4719100.0
2007-09-17 14:00:00	SPY	ETF	148.03	148.28	147.93	148.21	4795900.0
2007-09-17 14:30:00	SPY	ETF	148.21	148.38	148.0817	148.24	5292300.0
2007-09-17 15:00:00	SPY	ETF	148.24	148.52	148.13	148.26	7580300.0
2007-09-17 15:30:00	SPY	ETF	148.26	148.26	148.03	148.13	16417400.0
2007-09-17 16:00:00	SPY	ETF	148.14	148.23	148.03	148.13	1239000.0
2007-09-17 16:30:00	SPY	ETF	148.12	148.12	148.03	148.1	293600.0
2007-09-17 17:00:00	SPY	ETF	148.16	148.16	148.09	148.1	81800.0
2007-09-17 17:30:00	SPY	ETF	148.09	148.15	148.09	148.15	7300.0
2007-09-17 18:00:00	SPY	ETF	148.12	148.12	148.04	148.04	16400.0
2007-09-17 18:30:00	SPY	ETF	148.04	148.09	148.03	148.09	700.0
2007-09-17 19:00:00	SPY	ETF	148.08	148.08	148.03	148.05	2000.0
2007-09-17 19:30:00	SPY	ETF	148.07	148.08	148.02	148.03	15200.0
2007-09-17 04:00:00	QQQ	ETF	48.91	48.91	48.9	48.9	11000.0
2007-09-17 05:30:00	QQQ	ETF	48.89	48.89	48.89	48.89	100.0
2007-09-17 06:30:00	QQQ	ETF	48.92	48.95	48.92	48.95	54350.0
2007-09-17 07:00:00	QQQ	ETF	48.94	48.97	48.92	48.95	66453.0
2007-09-17 07:30:00	QQQ	ETF	48.97	48.97	48.93	48.97	41653.0
2007-09-17 08:00:00	QQQ	ETF	48.97	49.05	48.97	49.02	390677.0
2007-09-17 08:30:00	QQQ	ETF	49.02	49.07	48.98	49.05	745615.0
2007-09-17 09:00:00	QQQ	ETF	49.04	49.07	48.97	48.99	452977.0
2007-09-17 09:30:00	QQQ	ETF	48.99	49.1	48.86	48.9085	12908691.0
2007-09-17 10:00:00	QQQ	ETF	48.9	48.95	48.8	48.81	4859888.0
2007-09-17 10:30:00	QQQ	ETF	48.81	48.812	48.64	48.67	6793172.0
2007-09-17 11:00:00	QQQ	ETF	48.6795	48.77	48.65	48.66	3436010.0
2007-09-17 11:30:00	QQQ	ETF	48.66	48.67	48.59	48.65	3851803.0
2007-09-17 12:00:00	QQQ	ETF	48.66	48.72	48.62	48.7001	3579149.0
2007-09-17 12:30:00	QQQ	ETF	48.71	48.84	48.69	48.83	4543430.0
2007-09-17 13:00:00	QQQ	ETF	48.83	48.93	48.8	48.85	4163365.0
2007-09-17 13:30:00	QQQ	ETF	48.858	48.86	48.76	48.77	3653367.0
2007-09-17 14:00:00	QQQ	ETF	48.77	48.85	48.73	48.84	4204362.0

> showing 50 of 4,562 rows — these rows as CSV

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