PREVIEW / etf_30min / 2009-09-16

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-09-16.parquet
  size:    240 KB
  rows:    8,051

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-09-16 04:00:00	SPY	ETF	105.9	105.96	105.9	105.93	1700.0
2009-09-16 04:30:00	SPY	ETF	105.97	105.97	105.88	105.93	1000.0
2009-09-16 05:00:00	SPY	ETF	105.91	106.01	105.87	106.01	9500.0
2009-09-16 05:30:00	SPY	ETF	106.04	106.05	106.01	106.04	27400.0
2009-09-16 06:00:00	SPY	ETF	106.01	106.03	105.95	105.99	15000.0
2009-09-16 06:30:00	SPY	ETF	105.99	106.11	105.99	106.07	133858.0
2009-09-16 07:00:00	SPY	ETF	106.04	106.15	105.91	105.98	121987.0
2009-09-16 07:30:00	SPY	ETF	105.98	106.06	105.92	106.06	245679.0
2009-09-16 08:00:00	SPY	ETF	106.05	106.05	105.74	105.98	989755.0
2009-09-16 08:30:00	SPY	ETF	105.98	106.1	105.85	106.06	2067664.0
2009-09-16 09:00:00	SPY	ETF	106.06	106.29	106.03	106.1	2530955.0
2009-09-16 09:30:00	SPY	ETF	106.1	106.24	105.73	105.94	24265297.0
2009-09-16 10:00:00	SPY	ETF	105.93	106.26	105.93	106.05	18288536.0
2009-09-16 10:30:00	SPY	ETF	106.05	106.48	106.04	106.4	13128515.0
2009-09-16 11:00:00	SPY	ETF	106.41	106.48	106.28	106.28	9838669.0
2009-09-16 11:30:00	SPY	ETF	106.289	106.79	106.28	106.78	13586463.0
2009-09-16 12:00:00	SPY	ETF	106.78	106.99	106.75	106.84	10634127.0
2009-09-16 12:30:00	SPY	ETF	106.84	106.98	106.75	106.79	8816663.0
2009-09-16 13:00:00	SPY	ETF	106.79	107.24	106.78	107.201	12417075.0
2009-09-16 13:30:00	SPY	ETF	107.2	107.27	107.04	107.12	9803299.0
2009-09-16 14:00:00	SPY	ETF	107.12	107.31	107.1	107.14	12328988.0
2009-09-16 14:30:00	SPY	ETF	107.14	107.21	106.97	106.98	13969797.0
2009-09-16 15:00:00	SPY	ETF	106.98	107.18	106.91	107.16	16517713.0
2009-09-16 15:30:00	SPY	ETF	107.165	107.34	107.04	107.31	21418445.0
2009-09-16 16:00:00	SPY	ETF	107.3	107.345	106.14	107.23	7837783.0
2009-09-16 16:30:00	SPY	ETF	107.25	107.31	107.18	107.26	1807305.0
2009-09-16 17:00:00	SPY	ETF	107.27	107.39	105.98	107.32	186528.0
2009-09-16 17:30:00	SPY	ETF	107.35	107.36	105.9694	106.43	167064.0
2009-09-16 18:00:00	SPY	ETF	107.33	107.33	106.1175	106.1899	113841.0
2009-09-16 18:30:00	SPY	ETF	106.24	107.28	105.75	107.22	170504.0
2009-09-16 19:00:00	SPY	ETF	107.22	107.29	105.9	107.29	23680.0
2009-09-16 19:30:00	SPY	ETF	107.3	107.4	107.27	107.35	45939.0
2009-09-16 04:00:00	QQQ	ETF	41.89	41.89	41.89	41.89	1000.0
2009-09-16 04:30:00	QQQ	ETF	41.92	41.92	41.92	41.92	1000.0
2009-09-16 05:00:00	QQQ	ETF	41.94	41.96	41.94	41.96	12500.0
2009-09-16 05:30:00	QQQ	ETF	41.92	41.92	41.92	41.92	2500.0
2009-09-16 06:00:00	QQQ	ETF	41.88	41.88	41.87	41.87	10000.0
2009-09-16 06:30:00	QQQ	ETF	41.9	41.94	41.9	41.93	804.0
2009-09-16 07:00:00	QQQ	ETF	41.94	41.98	41.86	41.89	87688.0
2009-09-16 07:30:00	QQQ	ETF	41.91	41.94	41.89	41.94	8685.0
2009-09-16 08:00:00	QQQ	ETF	41.94	41.97	41.89	41.93	486996.0
2009-09-16 08:30:00	QQQ	ETF	41.94	41.98	41.87	41.96	341692.0
2009-09-16 09:00:00	QQQ	ETF	41.96	42.03	41.95	41.99	440871.0
2009-09-16 09:30:00	QQQ	ETF	41.99	42.05	41.84	41.94	10730472.0
2009-09-16 10:00:00	QQQ	ETF	41.94	42.05	41.89	41.95	8173820.0
2009-09-16 10:30:00	QQQ	ETF	41.95	42.07	41.94	42.04	4585220.0
2009-09-16 11:00:00	QQQ	ETF	42.05	42.07	41.98	41.98	4104672.0
2009-09-16 11:30:00	QQQ	ETF	41.98	42.21	41.98	42.1999	5006928.0
2009-09-16 12:00:00	QQQ	ETF	42.2	42.41	42.18	42.34	7115418.0
2009-09-16 12:30:00	QQQ	ETF	42.33	42.36	42.22	42.23	3489336.0

> showing 50 of 8,051 rows — these rows as CSV

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