PREVIEW / etf_30min / 2011-08-19

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-08-19.parquet
  size:    301 KB
  rows:    10,040

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-08-19 04:00:00	SPY	ETF	113.2	113.26	112.74	113.14	8463.0
2011-08-19 04:30:00	SPY	ETF	112.98	113.16	112.83	113.16	4141.0
2011-08-19 05:00:00	SPY	ETF	113.28	113.4	113.08	113.3	2055.0
2011-08-19 05:30:00	SPY	ETF	113.3	113.47	112.83	112.91	72800.0
2011-08-19 06:00:00	SPY	ETF	112.81	113.17	112.8	113.1	11326.0
2011-08-19 06:30:00	SPY	ETF	113.04	113.13	112.47	112.95	214655.0
2011-08-19 07:00:00	SPY	ETF	113.01	113.26	112.67	113.2	1280952.0
2011-08-19 07:30:00	SPY	ETF	113.23	113.65	113.1	113.58	1285816.0
2011-08-19 08:00:00	SPY	ETF	113.58	114.21	113.045	113.71	4708683.0
2011-08-19 08:30:00	SPY	ETF	113.74	113.75	113.2	113.27	1732792.0
2011-08-19 09:00:00	SPY	ETF	113.27	113.36	112.77	112.97	4479153.0
2011-08-19 09:30:00	SPY	ETF	112.96	114.44	112.9	114.3116	53164288.0
2011-08-19 10:00:00	SPY	ETF	114.31	115.88	114.19	115.65	43621260.0
2011-08-19 10:30:00	SPY	ETF	115.64	115.74	114.62	114.85	25744738.0
2011-08-19 11:00:00	SPY	ETF	114.85	115.0	113.86	114.13	25578741.0
2011-08-19 11:30:00	SPY	ETF	114.12	114.69	113.75	114.64	24030875.0
2011-08-19 12:00:00	SPY	ETF	114.64	114.7	114.0	114.29	14761664.0
2011-08-19 12:30:00	SPY	ETF	114.3	114.6	114.19	114.29	17269771.0
2011-08-19 13:00:00	SPY	ETF	114.29	114.56	114.04	114.275	11230833.0
2011-08-19 13:30:00	SPY	ETF	114.25	114.31	113.64	113.85	17231209.0
2011-08-19 14:00:00	SPY	ETF	113.85	114.02	113.02	113.32	26267556.0
2011-08-19 14:30:00	SPY	ETF	113.3137	113.64	112.87	113.06	28373365.0
2011-08-19 15:00:00	SPY	ETF	113.06	113.32	112.54	113.18	36714180.0
2011-08-19 15:30:00	SPY	ETF	113.18	113.36	112.5	112.71	42958077.0
2011-08-19 16:00:00	SPY	ETF	112.71	115.4	112.63	112.86	27609939.0
2011-08-19 16:30:00	SPY	ETF	112.86	114.3952	112.63	112.68	14225676.0
2011-08-19 17:00:00	SPY	ETF	112.68	112.7	112.55	112.7	2764318.0
2011-08-19 17:30:00	SPY	ETF	112.66	112.77	112.55	112.73	318291.0
2011-08-19 18:00:00	SPY	ETF	112.73	113.03	112.68	113.0	476301.0
2011-08-19 18:30:00	SPY	ETF	113.01	113.07	113.0	113.02	42851.0
2011-08-19 19:00:00	SPY	ETF	113.01	113.01	112.85	112.89	114059.0
2011-08-19 19:30:00	SPY	ETF	112.86	112.93	112.81	112.93	40821.0
2011-08-19 04:00:00	QQQ	ETF	50.38	50.54	50.21	50.54	6095.0
2011-08-19 04:30:00	QQQ	ETF	50.31	50.31	50.31	50.31	100.0
2011-08-19 05:30:00	QQQ	ETF	50.55	50.55	50.37	50.38	1100.0
2011-08-19 06:00:00	QQQ	ETF	50.42	50.49	50.37	50.37	1300.0
2011-08-19 06:30:00	QQQ	ETF	50.3	50.36	50.11	50.33	17600.0
2011-08-19 07:00:00	QQQ	ETF	50.32	50.53	50.19	50.51	145629.0
2011-08-19 07:30:00	QQQ	ETF	50.53	50.85	50.49	50.8	166749.0
2011-08-19 08:00:00	QQQ	ETF	50.79	51.01	50.39	50.78	2081600.0
2011-08-19 08:30:00	QQQ	ETF	50.75	50.79	50.56	50.58	845654.0
2011-08-19 09:00:00	QQQ	ETF	50.57	50.58	50.4	50.45	972043.0
2011-08-19 09:30:00	QQQ	ETF	50.43	51.16	50.41	51.09	11506647.0
2011-08-19 10:00:00	QQQ	ETF	51.09	51.67	50.994	51.57	11421565.0
2011-08-19 10:30:00	QQQ	ETF	51.57	51.63	51.13	51.24	6989915.0
2011-08-19 11:00:00	QQQ	ETF	51.24	51.33	50.77	50.92	4682123.0
2011-08-19 11:30:00	QQQ	ETF	50.92	51.18	50.79	51.17	5263040.0
2011-08-19 12:00:00	QQQ	ETF	51.16	51.2	50.89	51.006	3509414.0
2011-08-19 12:30:00	QQQ	ETF	51.01	51.13	50.94	50.98	3427915.0
2011-08-19 13:00:00	QQQ	ETF	50.977	51.07	50.88	50.92	2558429.0

> showing 50 of 10,040 rows — these rows as CSV

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