PREVIEW / etf_30min / 2007-06-20

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-06-20.parquet
  size:    121 KB
  rows:    4,473

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-06-20 04:00:00	SPY	ETF	153.49	153.49	153.49	153.49	400.0
2007-06-20 06:00:00	SPY	ETF	153.62	153.62	153.62	153.62	4500.0
2007-06-20 06:30:00	SPY	ETF	153.62	153.63	153.59	153.63	22100.0
2007-06-20 07:00:00	SPY	ETF	153.57	153.61	153.51	153.58	64400.0
2007-06-20 07:30:00	SPY	ETF	153.59	153.65	153.58	153.65	230200.0
2007-06-20 08:00:00	SPY	ETF	153.64	153.8	153.62	153.75	630100.0
2007-06-20 08:30:00	SPY	ETF	153.74	153.76	153.67	153.72	1021900.0
2007-06-20 09:00:00	SPY	ETF	153.71	153.72	153.27	153.57	1153000.0
2007-06-20 09:30:00	SPY	ETF	153.58	153.58	152.96	152.98	16660225.0
2007-06-20 10:00:00	SPY	ETF	152.98	153.05	152.64	153.03	13689573.0
2007-06-20 10:30:00	SPY	ETF	153.04	153.43	152.94	153.27	11770563.0
2007-06-20 11:00:00	SPY	ETF	153.27	153.58	152.95	153.15	8447509.0
2007-06-20 11:30:00	SPY	ETF	153.15	153.17	152.7	152.85	9802536.0
2007-06-20 12:00:00	SPY	ETF	152.85	152.93	152.58	152.85	12693340.0
2007-06-20 12:30:00	SPY	ETF	152.85	152.97	152.82	152.84	2948700.0
2007-06-20 13:00:00	SPY	ETF	152.84	152.85	152.19	152.38	19419084.0
2007-06-20 13:30:00	SPY	ETF	152.39	153.1375	152.32	152.42	11429071.0
2007-06-20 14:00:00	SPY	ETF	152.43	152.71	152.07	152.23	14168046.0
2007-06-20 14:30:00	SPY	ETF	152.23	152.32	151.95	152.2	14457685.0
2007-06-20 15:00:00	SPY	ETF	152.21	152.58	151.66	151.77	12364108.0
2007-06-20 15:30:00	SPY	ETF	151.78	151.85	150.96	151.0	21002000.0
2007-06-20 16:00:00	SPY	ETF	151.0	152.75	150.99	151.07	2588600.0
2007-06-20 16:30:00	SPY	ETF	151.1	152.15	151.01	151.15	366300.0
2007-06-20 17:00:00	SPY	ETF	151.15	151.17	151.09	151.15	156100.0
2007-06-20 17:30:00	SPY	ETF	151.19	151.2	151.11	151.14	6600.0
2007-06-20 18:00:00	SPY	ETF	151.14	151.25	151.14	151.17	59900.0
2007-06-20 18:30:00	SPY	ETF	151.19	151.2	151.17	151.19	6300.0
2007-06-20 19:00:00	SPY	ETF	151.2	151.21	151.2	151.21	1000.0
2007-06-20 19:30:00	SPY	ETF	151.24	151.24	151.18	151.22	6300.0
2007-06-20 06:00:00	QQQ	ETF	47.88	47.88	47.88	47.88	300.0
2007-06-20 07:00:00	QQQ	ETF	47.88	47.89	47.86	47.88	30300.0
2007-06-20 07:30:00	QQQ	ETF	47.89	47.91	47.87	47.9	134216.0
2007-06-20 08:00:00	QQQ	ETF	47.9	47.96	47.9	47.94	272595.0
2007-06-20 08:30:00	QQQ	ETF	47.92	47.95	47.91	47.93	1040787.0
2007-06-20 09:00:00	QQQ	ETF	47.93	47.93	47.84	47.84	1113120.0
2007-06-20 09:30:00	QQQ	ETF	47.83	47.85	47.61	47.64	12124776.0
2007-06-20 10:00:00	QQQ	ETF	47.64	47.71	47.57	47.7	11864039.0
2007-06-20 10:30:00	QQQ	ETF	47.7	47.92	47.7	47.88	23459338.0
2007-06-20 11:00:00	QQQ	ETF	47.88	47.89	47.78	47.84	7139462.0
2007-06-20 11:30:00	QQQ	ETF	47.84	47.84	47.71	47.76	10002478.0
2007-06-20 12:00:00	QQQ	ETF	47.761	47.83	47.69	47.8005	6408010.0
2007-06-20 12:30:00	QQQ	ETF	47.8	47.85	47.77	47.8	1897288.0
2007-06-20 13:00:00	QQQ	ETF	47.79	47.8	47.51	47.59	12804911.0
2007-06-20 13:30:00	QQQ	ETF	47.59	47.7	47.58	47.65	6841694.0
2007-06-20 14:00:00	QQQ	ETF	47.65	47.74	47.54	47.58	9286499.0
2007-06-20 14:30:00	QQQ	ETF	47.59	47.63	47.49	47.58	11495370.0
2007-06-20 15:00:00	QQQ	ETF	47.584	47.584	47.42	47.45	11063587.0
2007-06-20 15:30:00	QQQ	ETF	47.45	47.515	47.24	47.26	20533199.0
2007-06-20 16:00:00	QQQ	ETF	47.27	47.69	47.25	47.33	3414067.0
2007-06-20 16:30:00	QQQ	ETF	47.32	47.34	47.29	47.31	5290622.0

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

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