PREVIEW / etf_30min / 2017-05-01

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-05-01.parquet
  size:    433 KB
  rows:    14,760

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-05-01 04:00:00	SPY	ETF	238.1	238.42	238.1	238.42	3330.0
2017-05-01 04:30:00	SPY	ETF	238.42	238.43	238.37	238.37	1600.0
2017-05-01 05:00:00	SPY	ETF	238.37	238.44	238.37	238.39	11541.0
2017-05-01 05:30:00	SPY	ETF	238.39	238.44	238.38	238.44	13855.0
2017-05-01 06:00:00	SPY	ETF	238.44	238.56	238.44	238.56	14263.0
2017-05-01 06:30:00	SPY	ETF	238.56	238.56	238.55	238.56	21741.0
2017-05-01 07:00:00	SPY	ETF	238.55	238.59	238.55	238.58	20195.0
2017-05-01 07:30:00	SPY	ETF	238.58	238.61	238.55	238.6	49753.0
2017-05-01 08:00:00	SPY	ETF	238.6	238.85	238.55	238.78	298945.0
2017-05-01 08:30:00	SPY	ETF	238.73	238.76	238.65	238.67	77797.0
2017-05-01 09:00:00	SPY	ETF	238.67	238.71	238.63	238.66	112780.0
2017-05-01 09:30:00	SPY	ETF	238.68	238.7	238.42	238.5	4976550.0
2017-05-01 10:00:00	SPY	ETF	238.49	238.5	238.195	238.355	3196261.0
2017-05-01 10:30:00	SPY	ETF	238.355	238.84	238.34	238.77	3312795.0
2017-05-01 11:00:00	SPY	ETF	238.765	238.83	238.63	238.64	1958789.0
2017-05-01 11:30:00	SPY	ETF	238.645	238.8399	238.59	238.74	2070862.0
2017-05-01 12:00:00	SPY	ETF	238.74	238.87	238.67	238.76	1878916.0
2017-05-01 12:30:00	SPY	ETF	238.75	238.87	238.25	238.56	3474175.0
2017-05-01 13:00:00	SPY	ETF	238.56	238.77	238.49	238.72	1581400.0
2017-05-01 13:30:00	SPY	ETF	238.73	239.03	238.7	239.02	1922025.0
2017-05-01 14:00:00	SPY	ETF	239.025	239.17	238.97	239.005	3178770.0
2017-05-01 14:30:00	SPY	ETF	239.01	239.06	238.85	238.94	2059998.0
2017-05-01 15:00:00	SPY	ETF	238.935	239.07	238.87	238.91	3576140.0
2017-05-01 15:30:00	SPY	ETF	238.91	239.12	238.61	238.65	8208028.0
2017-05-01 16:00:00	SPY	ETF	238.65	238.8667	238.5468	238.73	17994958.0
2017-05-01 16:30:00	SPY	ETF	238.73	238.78	238.67	238.78	238360.0
2017-05-01 17:00:00	SPY	ETF	238.75	238.78	238.64	238.67	2761280.0
2017-05-01 17:30:00	SPY	ETF	238.66	238.68	238.55	238.68	154202.0
2017-05-01 18:00:00	SPY	ETF	238.67	238.78	238.62	238.76	160110.0
2017-05-01 18:30:00	SPY	ETF	238.76	238.8	238.72	238.72	17873.0
2017-05-01 19:00:00	SPY	ETF	238.73	238.76	238.72	238.76	4800.0
2017-05-01 19:30:00	SPY	ETF	238.74	238.74	238.71	238.73	13350.0
2017-05-01 04:00:00	QQQ	ETF	136.11	136.27	136.11	136.27	1700.0
2017-05-01 05:30:00	QQQ	ETF	136.28	136.35	136.25	136.25	19800.0
2017-05-01 06:00:00	QQQ	ETF	136.35	136.35	136.31	136.31	1100.0
2017-05-01 06:30:00	QQQ	ETF	136.35	136.35	136.35	136.35	100.0
2017-05-01 07:00:00	QQQ	ETF	136.29	136.35	136.29	136.32	14282.0
2017-05-01 07:30:00	QQQ	ETF	136.34	136.35	136.32	136.32	11881.0
2017-05-01 08:00:00	QQQ	ETF	136.27	136.45	136.27	136.43	63479.0
2017-05-01 08:30:00	QQQ	ETF	136.41	136.5	136.41	136.45	79994.0
2017-05-01 09:00:00	QQQ	ETF	136.45	136.51	136.44	136.45	135642.0
2017-05-01 09:30:00	QQQ	ETF	136.46	136.67	136.38	136.6276	2150022.0
2017-05-01 10:00:00	QQQ	ETF	136.61	136.68	136.46	136.65	1202307.0
2017-05-01 10:30:00	QQQ	ETF	136.64	136.91	136.64	136.85	1970393.0
2017-05-01 11:00:00	QQQ	ETF	136.86	136.92	136.81	136.81	1071301.0
2017-05-01 11:30:00	QQQ	ETF	136.815	136.99	136.81	136.9211	926445.0
2017-05-01 12:00:00	QQQ	ETF	136.93	136.99	136.89	136.96	589098.0
2017-05-01 12:30:00	QQQ	ETF	136.97	137.06	136.81	136.95	1125210.0
2017-05-01 13:00:00	QQQ	ETF	136.96	137.11	136.94	137.0939	574603.0
2017-05-01 13:30:00	QQQ	ETF	137.09	137.23	137.08	137.23	722167.0

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

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