PREVIEW / etf_30min / 2011-03-11

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-03-11.parquet
  size:    289 KB
  rows:    9,377

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
2011-03-11 04:00:00	SPY	ETF	129.85	129.85	129.37	129.37	4699.0
2011-03-11 04:30:00	SPY	ETF	129.34	129.34	129.3	129.31	3100.0
2011-03-11 05:00:00	SPY	ETF	129.15	129.15	128.92	129.08	33636.0
2011-03-11 05:30:00	SPY	ETF	129.09	129.38	129.09	129.38	500.0
2011-03-11 06:00:00	SPY	ETF	129.29	129.29	128.99	129.29	74600.0
2011-03-11 06:30:00	SPY	ETF	129.31	129.61	129.21	129.5	196350.0
2011-03-11 07:00:00	SPY	ETF	129.45	129.76	129.27	129.66	1106160.0
2011-03-11 07:30:00	SPY	ETF	129.66	129.79	129.54	129.71	665900.0
2011-03-11 08:00:00	SPY	ETF	129.7	129.85	129.41	129.8	1908938.0
2011-03-11 08:30:00	SPY	ETF	129.8	129.95	129.48	129.6	2878656.0
2011-03-11 09:00:00	SPY	ETF	129.59	129.61	129.38	129.51	2264500.0
2011-03-11 09:30:00	SPY	ETF	129.52	130.26	129.49	130.03	38669948.0
2011-03-11 10:00:00	SPY	ETF	130.03	130.21	129.64	129.8901	16094520.0
2011-03-11 10:30:00	SPY	ETF	129.92	130.09	129.76	130.0701	13294237.0
2011-03-11 11:00:00	SPY	ETF	130.08	130.21	129.86	130.09	10338039.0
2011-03-11 11:30:00	SPY	ETF	130.091	130.63	130.06	130.53	16608679.0
2011-03-11 12:00:00	SPY	ETF	130.53	130.78	130.46	130.66	9652890.0
2011-03-11 12:30:00	SPY	ETF	130.67	130.71	130.52	130.65	5431768.0
2011-03-11 13:00:00	SPY	ETF	130.65	130.67	130.3	130.46	11618705.0
2011-03-11 13:30:00	SPY	ETF	130.46	130.62	130.41	130.47	4057281.0
2011-03-11 14:00:00	SPY	ETF	130.47	130.86	130.44	130.79	7235629.0
2011-03-11 14:30:00	SPY	ETF	130.8	130.95	130.78	130.89	8325890.0
2011-03-11 15:00:00	SPY	ETF	130.88	131.29	130.87	131.27	14363365.0
2011-03-11 15:30:00	SPY	ETF	131.27	131.31	130.84	130.84	22608864.0
2011-03-11 16:00:00	SPY	ETF	130.85	131.14	129.8	131.01	18500545.0
2011-03-11 16:30:00	SPY	ETF	131.01	138.8681	129.9649	131.0	18016438.0
2011-03-11 17:00:00	SPY	ETF	131.0	131.04	130.99	131.03	60481.0
2011-03-11 17:30:00	SPY	ETF	131.03	131.17	131.01	131.15	135834.0
2011-03-11 18:00:00	SPY	ETF	131.15	131.15	130.84	131.0	320062.0
2011-03-11 18:30:00	SPY	ETF	131.01	131.07	131.01	131.04	3210.0
2011-03-11 19:00:00	SPY	ETF	131.04	131.07	130.99	130.99	16850.0
2011-03-11 19:30:00	SPY	ETF	130.99	131.04	130.94	131.0	31150.0
2011-03-11 04:00:00	QQQ	ETF	55.95	55.95	55.8	55.8	1502.0
2011-03-11 05:00:00	QQQ	ETF	55.7	55.73	55.69	55.73	3100.0
2011-03-11 05:30:00	QQQ	ETF	55.75	55.88	55.75	55.88	11200.0
2011-03-11 06:00:00	QQQ	ETF	55.81	55.81	55.7	55.76	1400.0
2011-03-11 06:30:00	QQQ	ETF	55.81	55.93	55.76	55.92	17739.0
2011-03-11 07:00:00	QQQ	ETF	55.83	55.95	55.75	55.95	75894.0
2011-03-11 07:30:00	QQQ	ETF	55.88	56.0	55.88	55.97	100279.0
2011-03-11 08:00:00	QQQ	ETF	55.96	56.02	55.91	56.01	381775.0
2011-03-11 08:30:00	QQQ	ETF	55.95	56.09	55.88	55.95	684963.0
2011-03-11 09:00:00	QQQ	ETF	55.94	55.99	55.82	55.83	800788.0
2011-03-11 09:30:00	QQQ	ETF	55.85	56.26	55.82	56.11	18157249.0
2011-03-11 10:00:00	QQQ	ETF	56.11	56.16	55.89	56.02	6176069.0
2011-03-11 10:30:00	QQQ	ETF	56.01	56.09	55.91	56.07	8456712.0
2011-03-11 11:00:00	QQQ	ETF	56.08	56.18	55.97	56.14	3453378.0
2011-03-11 11:30:00	QQQ	ETF	56.15	56.38	56.125	56.36	6180456.0
2011-03-11 12:00:00	QQQ	ETF	56.36	56.45	56.29	56.4138	2275482.0
2011-03-11 12:30:00	QQQ	ETF	56.411	56.47	56.36	56.45	2415024.0
2011-03-11 13:00:00	QQQ	ETF	56.455	56.47	56.25	56.335	3780880.0

> showing 50 of 9,377 rows — these rows as CSV

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