PREVIEW / etf_30min / 2017-06-30

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-06-30.parquet
  size:    429 KB
  rows:    14,810

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
2017-06-30 04:00:00	SPY	ETF	241.72	241.72	241.72	241.72	1010.0
2017-06-30 04:30:00	SPY	ETF	241.6	241.79	241.5	241.79	1600.0
2017-06-30 05:00:00	SPY	ETF	241.79	241.95	241.79	241.94	36012.0
2017-06-30 05:30:00	SPY	ETF	241.97	242.1	241.97	242.1	22966.0
2017-06-30 06:00:00	SPY	ETF	242.14	242.42	242.14	242.29	42364.0
2017-06-30 06:30:00	SPY	ETF	242.32	242.33	242.25	242.3	12628.0
2017-06-30 07:00:00	SPY	ETF	242.28	242.4	242.27	242.3	171283.0
2017-06-30 07:30:00	SPY	ETF	242.28	242.34	242.23	242.3	86352.0
2017-06-30 08:00:00	SPY	ETF	242.34	242.37	242.06	242.12	237806.0
2017-06-30 08:30:00	SPY	ETF	242.11	242.2	241.97	242.0	362035.0
2017-06-30 09:00:00	SPY	ETF	242.01	242.29	241.95	242.27	467427.0
2017-06-30 09:30:00	SPY	ETF	242.28	242.55	242.06	242.1	8247705.0
2017-06-30 10:00:00	SPY	ETF	242.095	242.135	241.575	241.915	5433568.0
2017-06-30 10:30:00	SPY	ETF	241.92	242.02	241.58	241.89	4235021.0
2017-06-30 11:00:00	SPY	ETF	241.89	242.0	241.63	241.7	2257605.0
2017-06-30 11:30:00	SPY	ETF	241.7	242.15	241.5861	242.06	3119166.0
2017-06-30 12:00:00	SPY	ETF	242.07	242.16	241.97	242.0299	2450797.0
2017-06-30 12:30:00	SPY	ETF	242.025	242.1001	241.84	241.9417	1915644.0
2017-06-30 13:00:00	SPY	ETF	241.95	242.18	241.93	242.17	1535568.0
2017-06-30 13:30:00	SPY	ETF	242.165	242.2	242.04	242.105	2995598.0
2017-06-30 14:00:00	SPY	ETF	242.09	242.36	242.02	242.295	3176134.0
2017-06-30 14:30:00	SPY	ETF	242.291	242.55	242.2744	242.5	3846105.0
2017-06-30 15:00:00	SPY	ETF	242.5	242.54	242.32	242.48	3226446.0
2017-06-30 15:30:00	SPY	ETF	242.485	242.71	241.73	241.77	13611376.0
2017-06-30 16:00:00	SPY	ETF	241.77	242.47	241.72	241.89	13143918.0
2017-06-30 16:30:00	SPY	ETF	241.89	242.02	241.65	241.92	10028152.0
2017-06-30 17:00:00	SPY	ETF	241.91	242.01	241.8	241.9	2539595.0
2017-06-30 17:30:00	SPY	ETF	241.89	241.92	241.8	241.83	1463789.0
2017-06-30 18:00:00	SPY	ETF	241.82	241.86	241.65	241.67	116666.0
2017-06-30 18:30:00	SPY	ETF	241.67	241.72	241.65	241.72	11900.0
2017-06-30 19:00:00	SPY	ETF	241.7	241.7	241.62	241.66	20716.0
2017-06-30 19:30:00	SPY	ETF	241.68	241.7	241.66	241.67	10781.0
2017-06-30 04:00:00	QQQ	ETF	137.31	137.43	137.31	137.37	3000.0
2017-06-30 04:30:00	QQQ	ETF	137.28	137.75	137.28	137.75	12341.0
2017-06-30 05:00:00	QQQ	ETF	137.72	137.83	137.63	137.75	18000.0
2017-06-30 05:30:00	QQQ	ETF	137.82	137.98	137.82	137.98	4790.0
2017-06-30 06:00:00	QQQ	ETF	137.93	138.14	137.93	138.0	24150.0
2017-06-30 06:30:00	QQQ	ETF	138.0	138.32	137.88	138.09	13197.0
2017-06-30 07:00:00	QQQ	ETF	138.07	138.13	137.93	137.97	54368.0
2017-06-30 07:30:00	QQQ	ETF	137.97	137.97	137.84	137.94	189016.0
2017-06-30 08:00:00	QQQ	ETF	137.89	137.98	137.56	137.6	213809.0
2017-06-30 08:30:00	QQQ	ETF	137.65	137.71	137.35	137.54	386289.0
2017-06-30 09:00:00	QQQ	ETF	137.5	138.03	137.39	138.01	521530.0
2017-06-30 09:30:00	QQQ	ETF	138.0	138.33	137.66	137.7799	10715280.0
2017-06-30 10:00:00	QQQ	ETF	137.77	137.85	137.19	137.74	7931486.0
2017-06-30 10:30:00	QQQ	ETF	137.74	137.97	137.43	137.82	4394745.0
2017-06-30 11:00:00	QQQ	ETF	137.83	137.958	137.58	137.65	2001341.0
2017-06-30 11:30:00	QQQ	ETF	137.64	137.895	137.52	137.86	1910594.0
2017-06-30 12:00:00	QQQ	ETF	137.84	137.96	137.76	137.89	1365524.0
2017-06-30 12:30:00	QQQ	ETF	137.88	137.92	137.63	137.73	1012972.0

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

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