PREVIEW / etf_30min / 2009-08-20

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-08-20.parquet
  size:    218 KB
  rows:    7,278

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-20 04:00:00	SPY	ETF	100.67	100.7	100.67	100.7	1600.0
2009-08-20 04:30:00	SPY	ETF	100.76	100.77	100.72	100.76	975.0
2009-08-20 05:00:00	SPY	ETF	100.71	100.71	100.67	100.67	2100.0
2009-08-20 05:30:00	SPY	ETF	100.67	100.67	100.65	100.65	700.0
2009-08-20 06:00:00	SPY	ETF	100.63	100.63	100.45	100.58	33300.0
2009-08-20 06:30:00	SPY	ETF	100.49	100.55	100.47	100.54	44100.0
2009-08-20 07:00:00	SPY	ETF	100.56	100.57	100.28	100.4	373975.0
2009-08-20 07:30:00	SPY	ETF	100.42	100.59	100.38	100.59	404357.0
2009-08-20 08:00:00	SPY	ETF	100.57	100.75	100.15	100.6	1849813.0
2009-08-20 08:30:00	SPY	ETF	100.6	100.62	100.05	100.14	6324883.0
2009-08-20 09:00:00	SPY	ETF	100.14	100.14	99.89	100.09	2543894.0
2009-08-20 09:30:00	SPY	ETF	100.09	100.71	99.87	100.7	25394590.0
2009-08-20 10:00:00	SPY	ETF	100.7	100.78	100.39	100.6001	18790359.0
2009-08-20 10:30:00	SPY	ETF	100.61	100.93	100.6	100.79	13708492.0
2009-08-20 11:00:00	SPY	ETF	100.79	100.84	100.67	100.75	6380905.0
2009-08-20 11:30:00	SPY	ETF	100.76	100.8	100.58	100.69	8355999.0
2009-08-20 12:00:00	SPY	ETF	100.69	100.78	100.62	100.68	7718841.0
2009-08-20 12:30:00	SPY	ETF	100.68	100.88	100.67	100.78	5760602.0
2009-08-20 13:00:00	SPY	ETF	100.79	100.84	100.7	100.8199	3932805.0
2009-08-20 13:30:00	SPY	ETF	100.82	100.905	100.72	100.79	5267372.0
2009-08-20 14:00:00	SPY	ETF	100.79	100.88	100.73	100.74	6156683.0
2009-08-20 14:30:00	SPY	ETF	100.74	100.83	100.67	100.79	12371074.0
2009-08-20 15:00:00	SPY	ETF	100.78	101.09	100.78	101.0322	14980300.0
2009-08-20 15:30:00	SPY	ETF	101.03	101.22	100.99	101.02	24997369.0
2009-08-20 16:00:00	SPY	ETF	101.02	101.117	99.99	100.95	7663924.0
2009-08-20 16:30:00	SPY	ETF	100.95	100.96	100.9	100.91	253327.0
2009-08-20 17:00:00	SPY	ETF	100.91	100.94	100.84	100.87	82915.0
2009-08-20 17:30:00	SPY	ETF	100.87	100.89	100.8	100.84	128460.0
2009-08-20 18:00:00	SPY	ETF	100.84	100.86	100.83	100.83	23056.0
2009-08-20 18:30:00	SPY	ETF	100.83	100.86	100.83	100.84	19412.0
2009-08-20 19:00:00	SPY	ETF	100.86	100.86	100.83	100.85	20981.0
2009-08-20 19:30:00	SPY	ETF	100.85	100.88	100.83	100.84	48063.0
2009-08-20 06:30:00	QQQ	ETF	39.45	39.48	39.45	39.48	7600.0
2009-08-20 07:00:00	QQQ	ETF	39.46	39.46	39.33	39.37	774412.0
2009-08-20 07:30:00	QQQ	ETF	39.37	39.44	39.37	39.44	510535.0
2009-08-20 08:00:00	QQQ	ETF	39.45	39.56	39.385	39.52	3467999.0
2009-08-20 08:30:00	QQQ	ETF	39.52	39.52	39.26	39.29	2778678.0
2009-08-20 09:00:00	QQQ	ETF	39.29	39.29	39.17	39.28	594204.0
2009-08-20 09:30:00	QQQ	ETF	39.28	39.71	39.2	39.6996	12658372.0
2009-08-20 10:00:00	QQQ	ETF	39.7	39.71	39.52	39.6	6693639.0
2009-08-20 10:30:00	QQQ	ETF	39.61	39.75	39.59	39.63	6105270.0
2009-08-20 11:00:00	QQQ	ETF	39.64	39.67	39.59	39.61	2627783.0
2009-08-20 11:30:00	QQQ	ETF	39.62	39.63	39.54	39.559	3868175.0
2009-08-20 12:00:00	QQQ	ETF	39.56	39.61	39.55	39.6	2741153.0
2009-08-20 12:30:00	QQQ	ETF	39.6	39.68	39.58	39.65	2388284.0
2009-08-20 13:00:00	QQQ	ETF	39.65	39.68	39.62	39.68	822544.0
2009-08-20 13:30:00	QQQ	ETF	39.68	39.71	39.62	39.66	2628923.0
2009-08-20 14:00:00	QQQ	ETF	39.65	39.6972	39.64	39.65	1808614.0
2009-08-20 14:30:00	QQQ	ETF	39.66	39.67	39.6	39.65	2838730.0
2009-08-20 15:00:00	QQQ	ETF	39.65	39.76	39.64	39.75	4189635.0

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

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