PREVIEW / etf_30min / 2012-03-19

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-03-19.parquet
  size:    291 KB
  rows:    9,711

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
2012-03-19 04:00:00	SPY	ETF	140.5	140.5	140.0	140.0	32360.0
2012-03-19 04:30:00	SPY	ETF	139.94	139.97	139.85	139.92	53780.0
2012-03-19 05:30:00	SPY	ETF	140.04	140.09	140.03	140.09	15980.0
2012-03-19 06:00:00	SPY	ETF	140.01	140.1	139.97	140.03	16500.0
2012-03-19 06:30:00	SPY	ETF	139.96	140.12	139.96	140.07	980.0
2012-03-19 07:00:00	SPY	ETF	140.09	140.21	140.02	140.18	79739.0
2012-03-19 07:30:00	SPY	ETF	140.16	140.2	140.08	140.13	105112.0
2012-03-19 08:00:00	SPY	ETF	140.15	140.3	140.08	140.17	997480.0
2012-03-19 08:30:00	SPY	ETF	140.18	140.2	139.94	140.03	1363012.0
2012-03-19 09:00:00	SPY	ETF	140.03	140.24	140.0	140.24	629575.0
2012-03-19 09:30:00	SPY	ETF	140.21	140.62	140.11	140.55	15249187.0
2012-03-19 10:00:00	SPY	ETF	140.55	140.58	140.3	140.43	9829711.0
2012-03-19 10:30:00	SPY	ETF	140.44	140.62	140.43	140.5798	5789152.0
2012-03-19 11:00:00	SPY	ETF	140.58	140.58	140.4	140.511	7843245.0
2012-03-19 11:30:00	SPY	ETF	140.511	140.86	140.49	140.84	11045124.0
2012-03-19 12:00:00	SPY	ETF	140.84	140.95	140.83	140.9	7460070.0
2012-03-19 12:30:00	SPY	ETF	140.9	141.12	140.89	141.04	6844932.0
2012-03-19 13:00:00	SPY	ETF	141.04	141.26	141.01	141.215	6297070.0
2012-03-19 13:30:00	SPY	ETF	141.21	141.28	141.16	141.201	6461951.0
2012-03-19 14:00:00	SPY	ETF	141.2	141.25	141.15	141.21	6367844.0
2012-03-19 14:30:00	SPY	ETF	141.21	141.23	141.03	141.0691	4801688.0
2012-03-19 15:00:00	SPY	ETF	141.06	141.13	140.96	140.981	7284714.0
2012-03-19 15:30:00	SPY	ETF	140.99	141.05	140.76	140.85	15041555.0
2012-03-19 16:00:00	SPY	ETF	140.85	140.91	140.28	140.85	5903802.0
2012-03-19 16:30:00	SPY	ETF	140.86	141.18	140.86	140.93	2958885.0
2012-03-19 17:00:00	SPY	ETF	140.93	140.96	140.91	140.93	39371.0
2012-03-19 17:30:00	SPY	ETF	140.9	140.96	140.89	140.92	17020.0
2012-03-19 18:00:00	SPY	ETF	140.91	140.91	140.86	140.87	25639.0
2012-03-19 18:30:00	SPY	ETF	140.88	140.88	140.87	140.87	7498.0
2012-03-19 19:00:00	SPY	ETF	140.87	140.88	140.81	140.87	16929.0
2012-03-19 19:30:00	SPY	ETF	140.86	140.88	140.83	140.88	31930.0
2012-03-19 04:00:00	QQQ	ETF	66.5	66.5	66.5	66.5	300.0
2012-03-19 05:30:00	QQQ	ETF	66.52	66.52	66.52	66.52	4000.0
2012-03-19 06:00:00	QQQ	ETF	66.5	66.51	66.5	66.51	2500.0
2012-03-19 06:30:00	QQQ	ETF	66.54	66.54	66.54	66.54	1000.0
2012-03-19 07:00:00	QQQ	ETF	66.58	66.73	66.58	66.7	79000.0
2012-03-19 07:30:00	QQQ	ETF	66.71	66.72	66.62	66.62	170227.0
2012-03-19 08:00:00	QQQ	ETF	66.64	66.68	66.61	66.68	440030.0
2012-03-19 08:30:00	QQQ	ETF	66.67	66.74	66.29	66.44	3698250.0
2012-03-19 09:00:00	QQQ	ETF	66.43	66.6	66.39	66.6	829720.0
2012-03-19 09:30:00	QQQ	ETF	66.62	66.73	66.45	66.69	6535836.0
2012-03-19 10:00:00	QQQ	ETF	66.69	66.7	66.47	66.54	3870268.0
2012-03-19 10:30:00	QQQ	ETF	66.53	66.7	66.53	66.67	1989820.0
2012-03-19 11:00:00	QQQ	ETF	66.66	66.67	66.59	66.645	1958590.0
2012-03-19 11:30:00	QQQ	ETF	66.645	66.88	66.6325	66.88	4200060.0
2012-03-19 12:00:00	QQQ	ETF	66.88	66.98	66.8771	66.95	2924311.0
2012-03-19 12:30:00	QQQ	ETF	66.95	67.07	66.94	66.99	2672239.0
2012-03-19 13:00:00	QQQ	ETF	66.9979	67.09	66.98	67.09	1620535.0
2012-03-19 13:30:00	QQQ	ETF	67.089	67.13	67.03	67.09	2702812.0
2012-03-19 14:00:00	QQQ	ETF	67.09	67.14	67.06	67.12	1775881.0

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

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