PREVIEW / etf_30min / 2007-10-03

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-10-03.parquet
  size:    126 KB
  rows:    4,684

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-10-03 04:30:00	SPY	ETF	153.97	153.97	153.97	153.97	25000.0
2007-10-03 05:00:00	SPY	ETF	153.94	153.94	153.94	153.94	500.0
2007-10-03 05:30:00	SPY	ETF	153.96	153.97	153.94	153.94	33000.0
2007-10-03 06:00:00	SPY	ETF	153.94	154.04	153.94	154.04	2300.0
2007-10-03 06:30:00	SPY	ETF	154.02	154.02	154.01	154.01	15000.0
2007-10-03 07:00:00	SPY	ETF	154.03	154.05	153.78	153.8	493800.0
2007-10-03 07:30:00	SPY	ETF	153.73	153.79	153.66	153.72	227900.0
2007-10-03 08:00:00	SPY	ETF	153.72	153.94	153.66	153.79	1924400.0
2007-10-03 08:30:00	SPY	ETF	153.78	154.27	153.76	153.87	642400.0
2007-10-03 09:00:00	SPY	ETF	153.86	153.88	153.75	153.82	515200.0
2007-10-03 09:30:00	SPY	ETF	153.81	153.95	153.49	153.5	12144430.0
2007-10-03 10:00:00	SPY	ETF	153.5	154.06	153.01	154.0	13883050.0
2007-10-03 10:30:00	SPY	ETF	154.0	154.19	153.81	154.17	8359000.0
2007-10-03 11:00:00	SPY	ETF	154.17	154.36	154.0388	154.2	9133600.0
2007-10-03 11:30:00	SPY	ETF	154.2	154.41	154.15	154.33	7115900.0
2007-10-03 12:00:00	SPY	ETF	154.34	154.39	154.14	154.16	5366300.0
2007-10-03 12:30:00	SPY	ETF	154.17	154.24	154.08	154.24	2922800.0
2007-10-03 13:00:00	SPY	ETF	154.23	154.26	153.82	153.86	5141500.0
2007-10-03 13:30:00	SPY	ETF	153.86	153.97	153.65	153.79	6987400.0
2007-10-03 14:00:00	SPY	ETF	153.79	153.8	153.5	153.67	8939000.0
2007-10-03 14:30:00	SPY	ETF	153.66	153.75	153.45	153.71	7165064.0
2007-10-03 15:00:00	SPY	ETF	153.7	153.9	153.54	153.71	9850400.0
2007-10-03 15:30:00	SPY	ETF	153.701	153.88	153.6	153.8	9934200.0
2007-10-03 16:00:00	SPY	ETF	153.84	153.87	153.7301	153.75	3306200.0
2007-10-03 16:30:00	SPY	ETF	153.82	153.95	153.82	153.9	1419000.0
2007-10-03 17:00:00	SPY	ETF	153.9	153.94	153.9	153.93	217900.0
2007-10-03 17:30:00	SPY	ETF	153.92	153.96	153.78	153.96	1108500.0
2007-10-03 18:00:00	SPY	ETF	153.95	154.0	153.93	153.94	169300.0
2007-10-03 18:30:00	SPY	ETF	153.95	153.96	153.93	153.96	6600.0
2007-10-03 19:00:00	SPY	ETF	153.96	153.99	153.96	153.99	2200.0
2007-10-03 19:30:00	SPY	ETF	153.96	153.97	153.95	153.97	10800.0
2007-10-03 05:00:00	QQQ	ETF	51.88	51.88	51.86	51.87	100000.0
2007-10-03 07:00:00	QQQ	ETF	51.89	51.89	51.7	51.8	690455.0
2007-10-03 07:30:00	QQQ	ETF	51.8	51.8	51.73	51.77	384441.0
2007-10-03 08:00:00	QQQ	ETF	51.77	51.85	51.77	51.83	713055.0
2007-10-03 08:30:00	QQQ	ETF	51.83	51.97	51.82	51.85	415402.0
2007-10-03 09:00:00	QQQ	ETF	51.85	51.87	51.81	51.84	156662.0
2007-10-03 09:30:00	QQQ	ETF	51.83	51.88	51.66	51.66	8812527.0
2007-10-03 10:00:00	QQQ	ETF	51.6601	51.94	51.66	51.92	12386409.0
2007-10-03 10:30:00	QQQ	ETF	51.93	51.99	51.82	51.98	6001629.0
2007-10-03 11:00:00	QQQ	ETF	51.97	52.06	51.93	51.99	4239436.0
2007-10-03 11:30:00	QQQ	ETF	51.99	52.07	51.96	52.009	4103303.0
2007-10-03 12:00:00	QQQ	ETF	52.0006	52.01	51.92	51.93	2984919.0
2007-10-03 12:30:00	QQQ	ETF	51.93	51.96	51.89	51.96	2340481.0
2007-10-03 13:00:00	QQQ	ETF	51.96	51.98	51.77	51.82	6981261.0
2007-10-03 13:30:00	QQQ	ETF	51.82	51.86	51.71	51.76	5033470.0
2007-10-03 14:00:00	QQQ	ETF	51.76	51.76	51.62	51.68	6833736.0
2007-10-03 14:30:00	QQQ	ETF	51.68	51.72	51.5	51.608	11739853.0
2007-10-03 15:00:00	QQQ	ETF	51.61	51.72	51.57	51.66	6651305.0
2007-10-03 15:30:00	QQQ	ETF	51.66	51.73	51.62	51.69	9262256.0

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

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