PREVIEW / etf_30min / 2009-09-11

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-09-11.parquet
  size:    229 KB
  rows:    7,527

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-11 04:00:00	SPY	ETF	104.6	104.6	104.57	104.57	300.0
2009-09-11 04:30:00	SPY	ETF	104.57	104.69	104.57	104.69	2800.0
2009-09-11 05:00:00	SPY	ETF	104.75	104.85	104.75	104.85	578.0
2009-09-11 05:30:00	SPY	ETF	104.86	104.86	104.81	104.81	3879.0
2009-09-11 06:00:00	SPY	ETF	104.73	104.83	104.73	104.83	16050.0
2009-09-11 06:30:00	SPY	ETF	104.79	104.88	104.79	104.87	7300.0
2009-09-11 07:00:00	SPY	ETF	104.86	104.86	104.76	104.78	54621.0
2009-09-11 07:30:00	SPY	ETF	104.78	104.88	104.76	104.82	73662.0
2009-09-11 08:00:00	SPY	ETF	104.81	104.84	104.73	104.77	312669.0
2009-09-11 08:30:00	SPY	ETF	104.77	104.87	104.74	104.82	799829.0
2009-09-11 09:00:00	SPY	ETF	104.81	105.09	104.81	104.99	3213248.0
2009-09-11 09:30:00	SPY	ETF	104.99	105.28	104.84	105.19	25770267.0
2009-09-11 10:00:00	SPY	ETF	105.2	105.3	104.76	104.95	21498742.0
2009-09-11 10:30:00	SPY	ETF	104.94	105.2	104.94	105.07	9154518.0
2009-09-11 11:00:00	SPY	ETF	105.07	105.19	104.88	104.8801	7465041.0
2009-09-11 11:30:00	SPY	ETF	104.89	105.15	104.69	104.83	10104792.0
2009-09-11 12:00:00	SPY	ETF	104.84	105.05	104.55	104.58	6868242.0
2009-09-11 12:30:00	SPY	ETF	104.5886	104.61	104.28	104.56	9469740.0
2009-09-11 13:00:00	SPY	ETF	104.56	104.71	104.4845	104.62	5863242.0
2009-09-11 13:30:00	SPY	ETF	104.62	104.79	104.42	104.44	11170992.0
2009-09-11 14:00:00	SPY	ETF	104.43	104.74	104.43	104.7	6584187.0
2009-09-11 14:30:00	SPY	ETF	104.7	104.84	104.55	104.67	6179219.0
2009-09-11 15:00:00	SPY	ETF	104.68	104.92	104.6	104.9	6133806.0
2009-09-11 15:30:00	SPY	ETF	104.9001	104.98	104.71	104.75	13315363.0
2009-09-11 16:00:00	SPY	ETF	104.76	105.11	104.39	104.67	7688039.0
2009-09-11 16:30:00	SPY	ETF	104.67	104.79	104.67	104.71	172434.0
2009-09-11 17:00:00	SPY	ETF	104.71	104.73	104.6	104.64	110367.0
2009-09-11 17:30:00	SPY	ETF	104.6	104.71	104.6	104.71	28399.0
2009-09-11 18:00:00	SPY	ETF	104.68	104.79	104.6	104.66	65474.0
2009-09-11 18:30:00	SPY	ETF	104.7	104.72	104.66	104.7	14050.0
2009-09-11 19:00:00	SPY	ETF	104.7	104.72	104.67	104.72	11349.0
2009-09-11 19:30:00	SPY	ETF	104.72	104.78	104.66	104.75	20773.0
2009-09-11 20:00:00	SPY	ETF	104.75	104.75	104.75	104.75	100.0
2009-09-11 04:00:00	QQQ	ETF	41.44	41.45	41.44	41.45	400.0
2009-09-11 05:00:00	QQQ	ETF	41.54	41.54	41.54	41.54	585.0
2009-09-11 06:30:00	QQQ	ETF	41.53	41.55	41.53	41.55	400.0
2009-09-11 07:00:00	QQQ	ETF	41.53	41.55	41.53	41.55	1900.0
2009-09-11 07:30:00	QQQ	ETF	41.55	41.62	41.55	41.57	54450.0
2009-09-11 08:00:00	QQQ	ETF	41.59	41.59	41.54	41.56	86492.0
2009-09-11 08:30:00	QQQ	ETF	41.55	41.59	41.52	41.58	1986151.0
2009-09-11 09:00:00	QQQ	ETF	41.56	41.65	41.52	41.52	635013.0
2009-09-11 09:30:00	QQQ	ETF	41.51	41.58	41.41	41.53	11362925.0
2009-09-11 10:00:00	QQQ	ETF	41.53	41.61	41.38	41.5	11744409.0
2009-09-11 10:30:00	QQQ	ETF	41.49	41.61	41.49	41.54	4801024.0
2009-09-11 11:00:00	QQQ	ETF	41.54	41.62	41.46	41.4688	7508781.0
2009-09-11 11:30:00	QQQ	ETF	41.47	41.51	41.37	41.43	6461419.0
2009-09-11 12:00:00	QQQ	ETF	41.43	41.445	41.3	41.31	3783712.0
2009-09-11 12:30:00	QQQ	ETF	41.3199	41.39	41.22	41.36	6550539.0
2009-09-11 13:00:00	QQQ	ETF	41.37	41.45	41.33	41.43	6230975.0
2009-09-11 13:30:00	QQQ	ETF	41.42	41.46	41.23	41.33	3008760.0

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

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