PREVIEW / etf_30min / 2009-08-24

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-08-24.parquet
  size:    235 KB
  rows:    7,767

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-24 04:00:00	SPY	ETF	103.45	103.55	103.45	103.55	3750.0
2009-08-24 04:30:00	SPY	ETF	103.45	103.45	103.34	103.36	1500.0
2009-08-24 05:00:00	SPY	ETF	103.26	103.26	103.25	103.25	2700.0
2009-08-24 05:30:00	SPY	ETF	103.25	103.35	103.25	103.33	1400.0
2009-08-24 06:00:00	SPY	ETF	103.3	103.36	103.28	103.28	7100.0
2009-08-24 06:30:00	SPY	ETF	103.3	103.3	103.15	103.2	17200.0
2009-08-24 07:00:00	SPY	ETF	103.2	103.32	103.1	103.21	48259.0
2009-08-24 07:30:00	SPY	ETF	103.25	103.36	103.2	103.21	381972.0
2009-08-24 08:00:00	SPY	ETF	103.58	103.58	103.2	103.28	592112.0
2009-08-24 08:30:00	SPY	ETF	103.29	103.41	103.27	103.37	537299.0
2009-08-24 09:00:00	SPY	ETF	103.38	103.56	103.32	103.4	2226653.0
2009-08-24 09:30:00	SPY	ETF	103.39	103.71	103.21	103.57	28216921.0
2009-08-24 10:00:00	SPY	ETF	103.56	103.89	103.54	103.82	14413276.0
2009-08-24 10:30:00	SPY	ETF	103.83	103.86	103.63	103.85	8787153.0
2009-08-24 11:00:00	SPY	ETF	103.84	103.95	103.71	103.715	7711674.0
2009-08-24 11:30:00	SPY	ETF	103.72	103.76	103.6	103.6	7210350.0
2009-08-24 12:00:00	SPY	ETF	103.61	103.69	103.52	103.6	5320873.0
2009-08-24 12:30:00	SPY	ETF	103.5901	103.66	103.45	103.45	6748457.0
2009-08-24 13:00:00	SPY	ETF	103.47	103.47	102.8	102.8	19666821.0
2009-08-24 13:30:00	SPY	ETF	102.81	103.1	102.78	103.048	8974464.0
2009-08-24 14:00:00	SPY	ETF	103.04	103.21	102.96	103.03	9409277.0
2009-08-24 14:30:00	SPY	ETF	103.03	103.05	102.92	102.98	8500119.0
2009-08-24 15:00:00	SPY	ETF	102.99	103.75	102.59	102.87	18667173.0
2009-08-24 15:30:00	SPY	ETF	102.87	103.05	102.63	102.94	26631288.0
2009-08-24 16:00:00	SPY	ETF	102.94	103.5	102.85	102.89	11321714.0
2009-08-24 16:30:00	SPY	ETF	102.88	103.04	102.82	102.84	2051613.0
2009-08-24 17:00:00	SPY	ETF	102.86	102.87	102.82	102.82	88732.0
2009-08-24 17:30:00	SPY	ETF	102.84	102.84	102.75	102.82	116200.0
2009-08-24 18:00:00	SPY	ETF	102.82	102.96	102.81	102.84	116739.0
2009-08-24 18:30:00	SPY	ETF	102.83	102.83	102.74	102.77	24492.0
2009-08-24 19:00:00	SPY	ETF	102.73	102.76	102.67	102.67	22281.0
2009-08-24 19:30:00	SPY	ETF	102.68	102.69	102.63	102.69	29095.0
2009-08-24 04:00:00	QQQ	ETF	40.47	40.47	40.47	40.47	500.0
2009-08-24 05:30:00	QQQ	ETF	40.34	40.38	40.34	40.38	7200.0
2009-08-24 06:00:00	QQQ	ETF	40.36	40.36	40.34	40.34	5127.0
2009-08-24 06:30:00	QQQ	ETF	40.34	40.34	40.3	40.3	1361.0
2009-08-24 07:00:00	QQQ	ETF	40.28	40.34	40.26	40.33	52718.0
2009-08-24 07:30:00	QQQ	ETF	40.33	40.34	40.29	40.32	172231.0
2009-08-24 08:00:00	QQQ	ETF	40.3	40.49	40.28	40.33	460314.0
2009-08-24 08:30:00	QQQ	ETF	40.33	40.36	40.31	40.35	850251.0
2009-08-24 09:00:00	QQQ	ETF	40.35	40.39	40.32	40.36	1357826.0
2009-08-24 09:30:00	QQQ	ETF	40.36	40.5	40.27	40.4195	22836639.0
2009-08-24 10:00:00	QQQ	ETF	40.42	40.57	40.41	40.5301	7957291.0
2009-08-24 10:30:00	QQQ	ETF	40.53	40.55	40.49	40.54	4307959.0
2009-08-24 11:00:00	QQQ	ETF	40.54	40.57	40.51	40.52	5046252.0
2009-08-24 11:30:00	QQQ	ETF	40.51	40.52	40.4	40.4	5478105.0
2009-08-24 12:00:00	QQQ	ETF	40.4	40.45	40.36	40.4	2851268.0
2009-08-24 12:30:00	QQQ	ETF	40.4001	40.44	40.36	40.37	3436853.0
2009-08-24 13:00:00	QQQ	ETF	40.37	40.37	40.15	40.161	8815147.0
2009-08-24 13:30:00	QQQ	ETF	40.16	40.33	40.15	40.28	5279743.0

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

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