PREVIEW / etf_30min / 2007-04-17

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-04-17.parquet
  size:    106 KB
  rows:    3,784

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-17 06:00:00	SPY	ETF	146.35	146.35	146.35	146.35	2000.0
2007-04-17 06:30:00	SPY	ETF	146.37	146.4	146.32	146.4	62200.0
2007-04-17 07:00:00	SPY	ETF	146.38	146.45	146.37	146.45	12900.0
2007-04-17 07:30:00	SPY	ETF	146.44	146.48	146.41	146.45	108600.0
2007-04-17 08:00:00	SPY	ETF	146.45	146.48	146.32	146.4	986500.0
2007-04-17 08:30:00	SPY	ETF	146.43	147.16	146.25	147.04	6155100.0
2007-04-17 09:00:00	SPY	ETF	147.05	147.16	146.32	146.96	2540912.0
2007-04-17 09:30:00	SPY	ETF	146.97	147.06	146.65	146.9	15182147.0
2007-04-17 10:00:00	SPY	ETF	146.9	147.3	146.89	147.155	18587873.0
2007-04-17 10:30:00	SPY	ETF	147.16	147.36	147.05	147.22	7103250.0
2007-04-17 11:00:00	SPY	ETF	147.22	147.3	147.18	147.23	5015269.0
2007-04-17 11:30:00	SPY	ETF	147.22	147.4	147.2	147.27	6657497.0
2007-04-17 12:00:00	SPY	ETF	147.27	147.33	147.16	147.23	2863426.0
2007-04-17 12:30:00	SPY	ETF	147.23	147.26	146.98	147.02	4835086.0
2007-04-17 13:00:00	SPY	ETF	147.01	147.09	146.81	146.9	5855181.0
2007-04-17 13:30:00	SPY	ETF	146.89	147.01	146.88	146.95	4590746.0
2007-04-17 14:00:00	SPY	ETF	146.95	147.27	146.92	147.17	5930657.0
2007-04-17 14:30:00	SPY	ETF	147.18	147.23	147.08	147.18	4358159.0
2007-04-17 15:00:00	SPY	ETF	147.17	147.21	146.92	147.0	4747054.0
2007-04-17 15:30:00	SPY	ETF	147.0	147.15	146.9901	147.07	5792316.0
2007-04-17 16:00:00	SPY	ETF	147.08	147.15	146.96	147.09	1980800.0
2007-04-17 16:30:00	SPY	ETF	147.09	147.09	146.76	146.86	809600.0
2007-04-17 17:00:00	SPY	ETF	146.87	147.13	146.73	146.75	1026400.0
2007-04-17 17:30:00	SPY	ETF	146.77	146.83	146.76	146.8	546900.0
2007-04-17 18:00:00	SPY	ETF	146.83	146.84	146.82	146.84	5700.0
2007-04-17 18:30:00	SPY	ETF	146.85	146.85	146.83	146.83	500.0
2007-04-17 19:00:00	SPY	ETF	146.82	146.82	146.82	146.82	600.0
2007-04-17 19:30:00	SPY	ETF	146.82	146.83	146.82	146.83	2500.0
2007-04-17 06:30:00	QQQ	ETF	44.96	44.96	44.96	44.96	10000.0
2007-04-17 07:00:00	QQQ	ETF	44.96	45.0	44.96	44.97	258506.0
2007-04-17 07:30:00	QQQ	ETF	44.97	45.01	44.97	44.99	134474.0
2007-04-17 08:00:00	QQQ	ETF	44.99	45.0	44.96	44.98	542238.0
2007-04-17 08:30:00	QQQ	ETF	44.98	45.26	44.98	45.22	5111916.0
2007-04-17 09:00:00	QQQ	ETF	45.23	45.23	45.14	45.14	896703.0
2007-04-17 09:30:00	QQQ	ETF	45.14	45.16	44.96	45.06	15595700.0
2007-04-17 10:00:00	QQQ	ETF	45.06	45.19	45.05	45.1	8729400.0
2007-04-17 10:30:00	QQQ	ETF	45.09	45.2	45.06	45.13	5010600.0
2007-04-17 11:00:00	QQQ	ETF	45.14	45.17	45.11	45.13	3493100.0
2007-04-17 11:30:00	QQQ	ETF	45.13	45.19	45.12	45.13	3739600.0
2007-04-17 12:00:00	QQQ	ETF	45.14	45.15	45.09	45.1	2234200.0
2007-04-17 12:30:00	QQQ	ETF	45.1	45.13	45.01	45.04	3750400.0
2007-04-17 13:00:00	QQQ	ETF	45.04	45.07	44.97	45.02	5329400.0
2007-04-17 13:30:00	QQQ	ETF	45.02	45.07	45.01	45.04	1882500.0
2007-04-17 14:00:00	QQQ	ETF	45.04	45.15	45.03	45.14	4840700.0
2007-04-17 14:30:00	QQQ	ETF	45.15	45.17	45.09	45.14	3344800.0
2007-04-17 15:00:00	QQQ	ETF	45.13	45.15	45.07	45.1	3163200.0
2007-04-17 15:30:00	QQQ	ETF	45.09	45.15	45.08	45.1	5057800.0
2007-04-17 16:00:00	QQQ	ETF	45.11	45.31	45.1	45.26	5980104.0
2007-04-17 16:30:00	QQQ	ETF	45.25	45.26	45.05	45.07	1666166.0
2007-04-17 17:00:00	QQQ	ETF	45.06	45.07	45.01	45.02	877154.0

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

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