PREVIEW / etf_30min / 2016-01-20

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-01-20.parquet
  size:    446 KB
  rows:    14,969

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
2016-01-20 04:00:00	SPY	ETF	184.05	184.63	183.48	184.32	86806.0
2016-01-20 04:30:00	SPY	ETF	184.4	184.82	184.21	184.5	27047.0
2016-01-20 05:00:00	SPY	ETF	184.55	184.55	184.08	184.54	18358.0
2016-01-20 05:30:00	SPY	ETF	184.55	184.65	184.1	184.18	18075.0
2016-01-20 06:00:00	SPY	ETF	184.25	184.8	184.2	184.79	183504.0
2016-01-20 06:30:00	SPY	ETF	184.77	184.78	184.36	184.5	105400.0
2016-01-20 07:00:00	SPY	ETF	184.55	184.7	184.09	184.5	299520.0
2016-01-20 07:30:00	SPY	ETF	184.49	184.66	184.23	184.5	468463.0
2016-01-20 08:00:00	SPY	ETF	184.05	184.92	184.05	184.84	1144361.0
2016-01-20 08:30:00	SPY	ETF	184.86	185.29	184.59	185.03	1314499.0
2016-01-20 09:00:00	SPY	ETF	185.04	185.24	184.75	185.03	1436697.0
2016-01-20 09:30:00	SPY	ETF	185.03	185.81	184.0	184.149	24881674.0
2016-01-20 10:00:00	SPY	ETF	184.14	184.45	183.58	183.81	19333281.0
2016-01-20 10:30:00	SPY	ETF	183.81	183.89	182.3	182.34	21944929.0
2016-01-20 11:00:00	SPY	ETF	182.35	183.435	182.34	183.05	16086718.0
2016-01-20 11:30:00	SPY	ETF	183.03	183.58	182.24	182.468	12531758.0
2016-01-20 12:00:00	SPY	ETF	182.47	182.8	181.02	181.24	15860488.0
2016-01-20 12:30:00	SPY	ETF	181.24	182.65	181.02	182.6401	19724163.0
2016-01-20 13:00:00	SPY	ETF	182.65	183.07	181.77	182.45	16708604.0
2016-01-20 13:30:00	SPY	ETF	182.45	184.515	182.39	184.11	22844214.0
2016-01-20 14:00:00	SPY	ETF	184.11	184.65	183.51	183.96	17791900.0
2016-01-20 14:30:00	SPY	ETF	183.96	184.93	183.46	184.48	15322156.0
2016-01-20 15:00:00	SPY	ETF	184.48	187.495	184.24	187.32	28185165.0
2016-01-20 15:30:00	SPY	ETF	187.33	187.46	185.46	185.79	33398593.0
2016-01-20 16:00:00	SPY	ETF	185.78	186.23	184.0749	186.06	9981951.0
2016-01-20 16:30:00	SPY	ETF	186.07	186.09	185.6	185.77	1761945.0
2016-01-20 17:00:00	SPY	ETF	185.8	185.95	185.69	185.9101	365988.0
2016-01-20 17:30:00	SPY	ETF	185.91	186.07	185.9	186.07	162362.0
2016-01-20 18:00:00	SPY	ETF	186.07	186.75	185.82	186.63	587626.0
2016-01-20 18:30:00	SPY	ETF	186.69	187.0	186.4	186.6	122341.0
2016-01-20 19:00:00	SPY	ETF	186.6	187.25	185.81	186.97	157966.0
2016-01-20 19:30:00	SPY	ETF	186.92	187.25	186.75	187.12	97833.0
2016-01-20 20:00:00	SPY	ETF	185.7708	185.7708	185.7708	185.7708	550000.0
2016-01-20 04:00:00	QQQ	ETF	99.01	99.01	98.6	98.9	33338.0
2016-01-20 04:30:00	QQQ	ETF	99.09	99.3	98.84	99.17	3600.0
2016-01-20 05:00:00	QQQ	ETF	99.0	99.0	99.0	99.0	100.0
2016-01-20 05:30:00	QQQ	ETF	99.06	99.06	98.92	98.92	6700.0
2016-01-20 06:00:00	QQQ	ETF	99.02	99.3	98.98	99.3	5732.0
2016-01-20 06:30:00	QQQ	ETF	99.27	99.3	99.13	99.17	1900.0
2016-01-20 07:00:00	QQQ	ETF	99.18	99.28	98.98	99.19	40991.0
2016-01-20 07:30:00	QQQ	ETF	99.15	99.28	99.05	99.17	56143.0
2016-01-20 08:00:00	QQQ	ETF	99.17	101.06	99.0699	99.3	82871.0
2016-01-20 08:30:00	QQQ	ETF	99.29	99.65	99.2	99.53	132327.0
2016-01-20 09:00:00	QQQ	ETF	99.54	99.62	99.4	99.49	296759.0
2016-01-20 09:30:00	QQQ	ETF	99.48	99.86	98.61	98.74	9437132.0
2016-01-20 10:00:00	QQQ	ETF	98.73	99.02	98.4	98.69	8143026.0
2016-01-20 10:30:00	QQQ	ETF	98.69	98.71	97.73	97.79	6781383.0
2016-01-20 11:00:00	QQQ	ETF	97.79	98.56	97.78	98.34	5201824.0
2016-01-20 11:30:00	QQQ	ETF	98.35	98.82	97.92	98.1501	3464634.0
2016-01-20 12:00:00	QQQ	ETF	98.15	98.35	97.25	97.41	3999967.0

> showing 50 of 14,969 rows — these rows as CSV

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