PREVIEW / etf_30min / 2009-08-31

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-08-31.parquet
  size:    224 KB
  rows:    7,469

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
2009-08-31 04:00:00	SPY	ETF	102.43	102.47	102.38	102.47	36695.0
2009-08-31 04:30:00	SPY	ETF	102.43	102.68	102.43	102.67	2500.0
2009-08-31 05:00:00	SPY	ETF	102.69	102.79	102.64	102.64	1400.0
2009-08-31 05:30:00	SPY	ETF	102.61	102.61	102.61	102.61	500.0
2009-08-31 06:00:00	SPY	ETF	102.58	102.58	102.47	102.47	14960.0
2009-08-31 06:30:00	SPY	ETF	102.59	102.71	102.53	102.53	10738.0
2009-08-31 07:00:00	SPY	ETF	102.52	102.65	102.5	102.65	46907.0
2009-08-31 07:30:00	SPY	ETF	102.63	102.69	102.52	102.55	327176.0
2009-08-31 08:00:00	SPY	ETF	103.5	103.5	102.41	102.5	1004511.0
2009-08-31 08:30:00	SPY	ETF	102.5	102.58	102.45	102.57	547231.0
2009-08-31 09:00:00	SPY	ETF	102.56	103.38	102.36	102.37	1547839.0
2009-08-31 09:30:00	SPY	ETF	102.37	102.56	101.79	102.0799	32732808.0
2009-08-31 10:00:00	SPY	ETF	102.07	102.24	101.88	102.11	16119965.0
2009-08-31 10:30:00	SPY	ETF	102.11	102.41	101.93	102.29	12974790.0
2009-08-31 11:00:00	SPY	ETF	102.29	102.3	102.02	102.025	6089835.0
2009-08-31 11:30:00	SPY	ETF	102.03	102.25	102.01	102.15	5692790.0
2009-08-31 12:00:00	SPY	ETF	102.1599	102.25	102.02	102.08	5975051.0
2009-08-31 12:30:00	SPY	ETF	102.08	102.15	101.91	102.02	5131061.0
2009-08-31 13:00:00	SPY	ETF	102.02	102.08	101.92	102.02	5462777.0
2009-08-31 13:30:00	SPY	ETF	102.03	102.13	101.99	102.09	4569499.0
2009-08-31 14:00:00	SPY	ETF	102.09	102.16	102.0	102.1	3844464.0
2009-08-31 14:30:00	SPY	ETF	102.1	102.42	102.08	102.28	10492878.0
2009-08-31 15:00:00	SPY	ETF	102.28	102.28	101.95	102.15	16231350.0
2009-08-31 15:30:00	SPY	ETF	102.16	102.58	102.14	102.48	24496839.0
2009-08-31 16:00:00	SPY	ETF	102.51	102.59	102.1333	102.51	9817392.0
2009-08-31 16:30:00	SPY	ETF	102.54	102.6	102.48	102.52	529109.0
2009-08-31 17:00:00	SPY	ETF	102.48	102.55	102.47	102.51	113150.0
2009-08-31 17:30:00	SPY	ETF	102.54	103.27	102.51	102.57	1014050.0
2009-08-31 18:00:00	SPY	ETF	102.52	102.59	102.52	102.53	35664.0
2009-08-31 18:30:00	SPY	ETF	102.56	102.57	102.52	102.57	36440.0
2009-08-31 19:00:00	SPY	ETF	102.55	102.57	102.51	102.57	19440.0
2009-08-31 19:30:00	SPY	ETF	102.55	102.57	102.48	102.5	39825.0
2009-08-31 04:00:00	QQQ	ETF	40.08	40.08	40.04	40.04	1920.0
2009-08-31 05:30:00	QQQ	ETF	40.14	40.14	40.13	40.13	700.0
2009-08-31 06:00:00	QQQ	ETF	40.14	40.14	40.13	40.13	2860.0
2009-08-31 06:30:00	QQQ	ETF	40.14	40.2	40.14	40.19	1460.0
2009-08-31 07:00:00	QQQ	ETF	40.17	40.18	40.14	40.18	12800.0
2009-08-31 07:30:00	QQQ	ETF	40.15	40.15	40.15	40.15	2000.0
2009-08-31 08:00:00	QQQ	ETF	40.15	40.16	40.07	40.1	394193.0
2009-08-31 08:30:00	QQQ	ETF	40.09	40.14	40.06	40.1	443761.0
2009-08-31 09:00:00	QQQ	ETF	40.1	40.17	40.07	40.15	645753.0
2009-08-31 09:30:00	QQQ	ETF	40.16	40.2	39.79	39.88	16148191.0
2009-08-31 10:00:00	QQQ	ETF	39.87	39.92	39.79	39.87	9219604.0
2009-08-31 10:30:00	QQQ	ETF	39.88	40.05	39.8	39.97	8761080.0
2009-08-31 11:00:00	QQQ	ETF	39.98	39.98	39.82	39.83	3698184.0
2009-08-31 11:30:00	QQQ	ETF	39.82	39.94	39.82	39.9	3329869.0
2009-08-31 12:00:00	QQQ	ETF	39.9	39.95	39.86	39.9094	4631281.0
2009-08-31 12:30:00	QQQ	ETF	39.91	39.94	39.84	39.85	2313524.0
2009-08-31 13:00:00	QQQ	ETF	39.8599	39.88	39.81	39.839	2210130.0
2009-08-31 13:30:00	QQQ	ETF	39.84	39.88	39.81	39.86	2034762.0

> showing 50 of 7,469 rows — these rows as CSV

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