PREVIEW / etf_30min / 2007-07-20

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-07-20.parquet
  size:    127 KB
  rows:    4,746

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-07-20 04:00:00	SPY	ETF	155.06	155.06	155.06	155.06	1500.0
2007-07-20 04:30:00	SPY	ETF	154.92	154.92	154.87	154.87	4000.0
2007-07-20 05:00:00	SPY	ETF	154.79	154.9	154.79	154.9	6400.0
2007-07-20 05:30:00	SPY	ETF	154.94	154.94	154.94	154.94	1000.0
2007-07-20 06:00:00	SPY	ETF	154.92	155.06	154.92	155.06	5900.0
2007-07-20 06:30:00	SPY	ETF	155.11	155.14	155.11	155.13	11500.0
2007-07-20 07:00:00	SPY	ETF	155.01	155.02	154.81	154.95	182400.0
2007-07-20 07:30:00	SPY	ETF	154.88	154.88	154.59	154.67	436100.0
2007-07-20 08:00:00	SPY	ETF	154.6	154.76	154.57	154.69	1060600.0
2007-07-20 08:30:00	SPY	ETF	154.69	154.92	154.66	154.91	921000.0
2007-07-20 09:00:00	SPY	ETF	154.9	155.07	154.66	154.87	1919700.0
2007-07-20 09:30:00	SPY	ETF	154.89	154.99	154.09	154.32	20055657.0
2007-07-20 10:00:00	SPY	ETF	154.31	154.42	154.04	154.29	21137738.0
2007-07-20 10:30:00	SPY	ETF	154.3	154.39	153.78	154.03	18768333.0
2007-07-20 11:00:00	SPY	ETF	154.02	154.22	153.0	153.71	14421771.0
2007-07-20 11:30:00	SPY	ETF	153.71	153.8	153.31	153.35	16827772.0
2007-07-20 12:00:00	SPY	ETF	153.35	155.019	153.01	153.54	24460228.0
2007-07-20 12:30:00	SPY	ETF	153.55	153.56	152.83	152.92	12584148.0
2007-07-20 13:00:00	SPY	ETF	152.92	155.2484	152.9	153.4	12844866.0
2007-07-20 13:30:00	SPY	ETF	153.4	153.87	153.33	153.65	14569340.0
2007-07-20 14:00:00	SPY	ETF	153.66	154.15	153.49	153.77	17131686.0
2007-07-20 14:30:00	SPY	ETF	153.78	153.98	153.63	153.89	10406036.0
2007-07-20 15:00:00	SPY	ETF	153.89	154.1	153.56	153.74	12530006.0
2007-07-20 15:30:00	SPY	ETF	153.74	153.76	152.29	153.33	22157663.0
2007-07-20 16:00:00	SPY	ETF	153.33	153.8	153.28	153.6	6625800.0
2007-07-20 16:30:00	SPY	ETF	153.6	153.75	153.37	153.57	1340800.0
2007-07-20 17:00:00	SPY	ETF	153.57	153.6	153.5	153.54	449900.0
2007-07-20 17:30:00	SPY	ETF	153.54	153.54	153.49	153.49	56700.0
2007-07-20 18:00:00	SPY	ETF	153.49	153.49	153.38	153.38	21000.0
2007-07-20 18:30:00	SPY	ETF	153.38	153.38	153.38	153.38	900.0
2007-07-20 19:00:00	SPY	ETF	153.48	153.48	153.47	153.47	1300.0
2007-07-20 19:30:00	SPY	ETF	153.46	153.47	153.46	153.47	1300.0
2007-07-20 04:30:00	QQQ	ETF	50.22	50.22	50.22	50.22	200.0
2007-07-20 06:00:00	QQQ	ETF	50.25	50.29	50.25	50.29	25500.0
2007-07-20 06:30:00	QQQ	ETF	50.31	50.31	50.28	50.28	7500.0
2007-07-20 07:00:00	QQQ	ETF	50.27	50.31	50.25	50.31	112687.0
2007-07-20 07:30:00	QQQ	ETF	50.29	50.29	50.19	50.22	315961.0
2007-07-20 08:00:00	QQQ	ETF	50.2	50.23	50.19	50.23	695193.0
2007-07-20 08:30:00	QQQ	ETF	50.24	50.34	50.24	50.31	877725.0
2007-07-20 09:00:00	QQQ	ETF	50.3	50.31	50.18	50.3	1217777.0
2007-07-20 09:30:00	QQQ	ETF	50.29	50.36	50.01	50.07	15775377.0
2007-07-20 10:00:00	QQQ	ETF	50.07	50.15	50.01	50.13	15877253.0
2007-07-20 10:30:00	QQQ	ETF	50.14	50.17	49.98	50.09	10688395.0
2007-07-20 11:00:00	QQQ	ETF	50.08	50.17	50.01	50.04	8302807.0
2007-07-20 11:30:00	QQQ	ETF	50.04	50.06	49.87	49.91	13773368.0
2007-07-20 12:00:00	QQQ	ETF	49.91	49.98	49.77	49.98	14184570.0
2007-07-20 12:30:00	QQQ	ETF	49.97	49.98	49.74	49.79	15310836.0
2007-07-20 13:00:00	QQQ	ETF	49.8	49.9811	49.77	49.94	12790190.0
2007-07-20 13:30:00	QQQ	ETF	49.93	50.11	49.92	50.0611	6163215.0
2007-07-20 14:00:00	QQQ	ETF	50.06	50.22	50.03	50.13	10272559.0

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

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