PREVIEW / etf_30min / 2016-01-12

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-01-12.parquet
  size:    412 KB
  rows:    13,759

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-12 04:00:00	SPY	ETF	191.64	192.38	191.35	192.38	26094.0
2016-01-12 04:30:00	SPY	ETF	192.36	192.71	192.13	192.6	21381.0
2016-01-12 05:00:00	SPY	ETF	192.65	192.95	192.52	192.8	14430.0
2016-01-12 05:30:00	SPY	ETF	192.76	193.55	192.76	193.53	34091.0
2016-01-12 06:00:00	SPY	ETF	193.45	193.59	193.16	193.4	38371.0
2016-01-12 06:30:00	SPY	ETF	193.42	194.0	192.95	193.25	206408.0
2016-01-12 07:00:00	SPY	ETF	193.23	193.48	193.06	193.43	153469.0
2016-01-12 07:30:00	SPY	ETF	193.36	193.99	193.2	193.85	649899.0
2016-01-12 08:00:00	SPY	ETF	193.84	194.26	193.07	193.82	2093837.0
2016-01-12 08:30:00	SPY	ETF	193.81	193.96	193.64	193.92	706232.0
2016-01-12 09:00:00	SPY	ETF	193.93	194.02	193.62	193.84	1090743.0
2016-01-12 09:30:00	SPY	ETF	193.82	194.55	193.38	193.97	18854546.0
2016-01-12 10:00:00	SPY	ETF	193.975	194.17	192.9	193.09	16970731.0
2016-01-12 10:30:00	SPY	ETF	193.09	193.66	192.59	193.05	10840702.0
2016-01-12 11:00:00	SPY	ETF	193.0608	193.22	192.23	192.42	9454067.0
2016-01-12 11:30:00	SPY	ETF	192.4	194.41	191.77	192.52	11236273.0
2016-01-12 12:00:00	SPY	ETF	192.52	192.99	191.96	192.13	8101524.0
2016-01-12 12:30:00	SPY	ETF	192.135	192.32	191.44	191.75	9429458.0
2016-01-12 13:00:00	SPY	ETF	191.75	192.43	191.69	191.77	5899020.0
2016-01-12 13:30:00	SPY	ETF	191.76	192.5	191.62	191.87	5884128.0
2016-01-12 14:00:00	SPY	ETF	191.87	192.04	191.14	191.82	10787294.0
2016-01-12 14:30:00	SPY	ETF	191.82	192.94	191.74	192.84	12793281.0
2016-01-12 15:00:00	SPY	ETF	192.85	193.69	192.29	193.35	11902739.0
2016-01-12 15:30:00	SPY	ETF	193.34	194.01	193.1	193.62	20862639.0
2016-01-12 16:00:00	SPY	ETF	193.6	193.79	189.17	193.01	8414251.0
2016-01-12 16:30:00	SPY	ETF	193.02	193.16	192.76	192.8	1485281.0
2016-01-12 17:00:00	SPY	ETF	192.8	192.85	192.74	192.85	205427.0
2016-01-12 17:30:00	SPY	ETF	192.83	193.66	192.64	192.84	385915.0
2016-01-12 18:00:00	SPY	ETF	192.81	193.66	192.77	193.17	195633.0
2016-01-12 18:30:00	SPY	ETF	193.15	193.39	193.1	193.27	262551.0
2016-01-12 19:00:00	SPY	ETF	193.27	193.68	193.27	193.6	320977.0
2016-01-12 19:30:00	SPY	ETF	193.55	193.98	193.48	193.95	242621.0
2016-01-12 20:00:00	SPY	ETF	193.6283	193.6283	193.6283	193.6283	36500.0
2016-01-12 04:00:00	QQQ	ETF	103.94	104.11	103.94	104.11	310.0
2016-01-12 04:30:00	QQQ	ETF	104.64	104.69	104.64	104.68	12500.0
2016-01-12 05:00:00	QQQ	ETF	104.65	104.65	104.65	104.65	200.0
2016-01-12 05:30:00	QQQ	ETF	104.88	105.02	104.88	104.97	1860.0
2016-01-12 06:00:00	QQQ	ETF	105.13	105.2	105.05	105.13	9250.0
2016-01-12 06:30:00	QQQ	ETF	105.02	105.03	104.91	105.0	10000.0
2016-01-12 07:00:00	QQQ	ETF	105.03	105.21	104.95	105.19	22050.0
2016-01-12 07:30:00	QQQ	ETF	105.13	105.48	105.11	105.45	34542.0
2016-01-12 08:00:00	QQQ	ETF	105.43	105.73	105.04	105.41	240761.0
2016-01-12 08:30:00	QQQ	ETF	105.39	105.43	105.25	105.43	175456.0
2016-01-12 09:00:00	QQQ	ETF	105.42	105.47	105.22	105.32	203687.0
2016-01-12 09:30:00	QQQ	ETF	105.31	106.08	105.24	105.79	5968708.0
2016-01-12 10:00:00	QQQ	ETF	105.79	105.964	105.28	105.4	3689554.0
2016-01-12 10:30:00	QQQ	ETF	105.39	105.7499	105.06	105.35	2994239.0
2016-01-12 11:00:00	QQQ	ETF	105.345	105.41	104.89	105.04	2461669.0
2016-01-12 11:30:00	QQQ	ETF	105.04	105.16	104.63	105.07	2424785.0
2016-01-12 12:00:00	QQQ	ETF	105.08	105.32	104.69	104.81	1523241.0

> showing 50 of 13,759 rows — these rows as CSV

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