PREVIEW / etf_30min / 2018-06-27

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-06-27.parquet
  size:    484 KB
  rows:    16,797

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
2018-06-27 04:00:00	SPY	ETF	270.0	270.4	270.0	270.03	59196.0
2018-06-27 04:30:00	SPY	ETF	269.97	270.08	269.68	269.75	29580.0
2018-06-27 05:00:00	SPY	ETF	269.76	270.55	269.76	270.55	22590.0
2018-06-27 05:30:00	SPY	ETF	270.56	271.15	270.56	271.05	28858.0
2018-06-27 06:00:00	SPY	ETF	271.14	271.21	270.95	271.0	30000.0
2018-06-27 06:30:00	SPY	ETF	270.95	271.03	270.78	270.84	18350.0
2018-06-27 07:00:00	SPY	ETF	270.85	271.0	270.55	270.57	177710.0
2018-06-27 07:30:00	SPY	ETF	270.58	272.15	270.31	271.85	919643.0
2018-06-27 08:00:00	SPY	ETF	270.5601	272.34	270.06	271.73	731139.0
2018-06-27 08:30:00	SPY	ETF	271.72	272.42	271.72	271.89	411085.0
2018-06-27 09:00:00	SPY	ETF	271.88	272.28	271.88	272.25	296771.0
2018-06-27 09:30:00	SPY	ETF	272.26	273.29	272.03	273.29	6982048.0
2018-06-27 10:00:00	SPY	ETF	273.28	273.57	272.97	273.24	5013249.0
2018-06-27 10:30:00	SPY	ETF	273.24	273.865	273.235	273.35	5438889.0
2018-06-27 11:00:00	SPY	ETF	273.35	273.51	272.24	272.28	7550122.0
2018-06-27 11:30:00	SPY	ETF	272.28	272.93	272.04	272.7989	3906850.0
2018-06-27 12:00:00	SPY	ETF	272.79	273.25	272.655	272.66	1966550.0
2018-06-27 12:30:00	SPY	ETF	272.661	272.72	271.77	271.771	5547499.0
2018-06-27 13:00:00	SPY	ETF	271.78	272.05	270.6	271.0001	6292121.0
2018-06-27 13:30:00	SPY	ETF	271.0	271.33	270.45	270.87	5260537.0
2018-06-27 14:00:00	SPY	ETF	270.87	271.17	270.34	270.48	4159158.0
2018-06-27 14:30:00	SPY	ETF	270.48	271.05	269.98	270.13	5586478.0
2018-06-27 15:00:00	SPY	ETF	270.13	270.615	269.43	270.46	10131641.0
2018-06-27 15:30:00	SPY	ETF	270.47	270.645	269.18	269.27	20313572.0
2018-06-27 16:00:00	SPY	ETF	269.26	269.79	269.2349	269.58	11327212.0
2018-06-27 16:30:00	SPY	ETF	269.56	269.65	269.35	269.61	161811.0
2018-06-27 17:00:00	SPY	ETF	269.6	269.67	269.53	269.62	40544.0
2018-06-27 17:30:00	SPY	ETF	269.62	269.67	269.48	269.48	83035.0
2018-06-27 18:00:00	SPY	ETF	269.51	269.78	269.34	269.78	64492.0
2018-06-27 18:30:00	SPY	ETF	269.75	269.99	269.73	269.77	37961.0
2018-06-27 19:00:00	SPY	ETF	269.84	269.97	269.8	269.9	36955.0
2018-06-27 19:30:00	SPY	ETF	269.92	270.16	269.81	270.0	88570.0
2018-06-27 04:00:00	QQQ	ETF	170.8	170.84	170.48	170.61	26719.0
2018-06-27 04:30:00	QQQ	ETF	170.61	170.61	170.21	170.31	15722.0
2018-06-27 05:00:00	QQQ	ETF	170.37	170.94	170.36	170.94	25383.0
2018-06-27 05:30:00	QQQ	ETF	170.99	171.29	170.95	171.25	36653.0
2018-06-27 06:00:00	QQQ	ETF	171.28	171.3	171.18	171.25	22713.0
2018-06-27 06:30:00	QQQ	ETF	171.16	171.22	171.02	171.15	17248.0
2018-06-27 07:00:00	QQQ	ETF	171.11	171.25	170.96	170.96	85880.0
2018-06-27 07:30:00	QQQ	ETF	170.98	172.27	170.74	172.11	560612.0
2018-06-27 08:00:00	QQQ	ETF	172.17	172.7	170.78	172.22	397109.0
2018-06-27 08:30:00	QQQ	ETF	172.22	172.75	172.21	172.27	428331.0
2018-06-27 09:00:00	QQQ	ETF	172.28	172.85	172.28	172.79	300309.0
2018-06-27 09:30:00	QQQ	ETF	172.77	173.34	172.48	173.29	3812716.0
2018-06-27 10:00:00	QQQ	ETF	173.29	173.31	172.75	173.03	2721697.0
2018-06-27 10:30:00	QQQ	ETF	173.03	173.58	172.95	172.95	2021706.0
2018-06-27 11:00:00	QQQ	ETF	172.95	173.115	172.25	172.3	4135594.0
2018-06-27 11:30:00	QQQ	ETF	172.299	172.69	172.08	172.601	1929720.0
2018-06-27 12:00:00	QQQ	ETF	172.59	172.84	172.34	172.36	1301280.0
2018-06-27 12:30:00	QQQ	ETF	172.36	172.4	171.591	171.591	2342396.0

> showing 50 of 16,797 rows — these rows as CSV

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