PREVIEW / etf_30min / 2017-03-16

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-03-16.parquet
  size:    428 KB
  rows:    14,734

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-03-16 04:00:00	SPY	ETF	239.44	239.75	239.39	239.42	5254.0
2017-03-16 04:30:00	SPY	ETF	239.38	239.45	239.25	239.3	17380.0
2017-03-16 05:00:00	SPY	ETF	239.3	239.36	239.27	239.33	3770.0
2017-03-16 05:30:00	SPY	ETF	239.34	239.45	239.34	239.35	5908.0
2017-03-16 06:00:00	SPY	ETF	239.4	239.4	239.27	239.28	18596.0
2017-03-16 06:30:00	SPY	ETF	239.29	239.44	239.29	239.41	76332.0
2017-03-16 07:00:00	SPY	ETF	239.37	239.42	239.37	239.38	157412.0
2017-03-16 07:30:00	SPY	ETF	239.38	239.42	239.25	239.27	85182.0
2017-03-16 08:00:00	SPY	ETF	239.26	239.41	239.06	239.1	288781.0
2017-03-16 08:30:00	SPY	ETF	239.1	239.21	239.02	239.19	167052.0
2017-03-16 09:00:00	SPY	ETF	239.18	239.26	239.1	239.1	299936.0
2017-03-16 09:30:00	SPY	ETF	239.11	239.2	238.89	239.005	10967847.0
2017-03-16 10:00:00	SPY	ETF	239.0027	239.19	238.525	238.75	7438325.0
2017-03-16 10:30:00	SPY	ETF	238.75	238.87	238.55	238.695	4816450.0
2017-03-16 11:00:00	SPY	ETF	238.7	238.72	238.21	238.26	7578390.0
2017-03-16 11:30:00	SPY	ETF	238.27	238.5	238.13	238.4796	4938125.0
2017-03-16 12:00:00	SPY	ETF	238.48	238.69	238.31	238.66	3094444.0
2017-03-16 12:30:00	SPY	ETF	238.67	238.76	238.57	238.69	2571365.0
2017-03-16 13:00:00	SPY	ETF	238.68	238.69	238.39	238.42	2210140.0
2017-03-16 13:30:00	SPY	ETF	238.42	238.72	238.4	238.585	3809542.0
2017-03-16 14:00:00	SPY	ETF	238.585	238.69	238.53	238.645	2374038.0
2017-03-16 14:30:00	SPY	ETF	238.64	238.69	238.21	238.26	4110411.0
2017-03-16 15:00:00	SPY	ETF	238.255	238.52	238.1	238.4	5651982.0
2017-03-16 15:30:00	SPY	ETF	238.395	238.575	238.28	238.52	9700666.0
2017-03-16 16:00:00	SPY	ETF	238.52	238.67	238.46	238.65	4745206.0
2017-03-16 16:30:00	SPY	ETF	238.66	238.8	238.48	238.66	1335511.0
2017-03-16 17:00:00	SPY	ETF	238.69	238.69	238.5412	238.64	139262.0
2017-03-16 17:30:00	SPY	ETF	238.65	238.69	238.48	238.69	341318.0
2017-03-16 18:00:00	SPY	ETF	238.68	238.68	238.48	238.62	300564.0
2017-03-16 18:30:00	SPY	ETF	238.65	238.66	238.62	238.66	8531.0
2017-03-16 19:00:00	SPY	ETF	238.64	238.65	238.53	238.53	12893.0
2017-03-16 19:30:00	SPY	ETF	238.58	238.6	238.55	238.6	10370.0
2017-03-16 04:00:00	QQQ	ETF	132.29	132.59	132.29	132.57	848.0
2017-03-16 05:30:00	QQQ	ETF	132.53	132.58	132.53	132.58	15099.0
2017-03-16 06:00:00	QQQ	ETF	132.54	132.57	132.54	132.57	20729.0
2017-03-16 06:30:00	QQQ	ETF	132.5	132.5	132.5	132.5	100.0
2017-03-16 07:00:00	QQQ	ETF	132.52	132.52	132.52	132.52	2889.0
2017-03-16 07:30:00	QQQ	ETF	132.52	132.53	132.46	132.47	3700.0
2017-03-16 08:00:00	QQQ	ETF	132.49	132.54	132.3	132.31	67826.0
2017-03-16 08:30:00	QQQ	ETF	132.34	132.38	132.33	132.38	36931.0
2017-03-16 09:00:00	QQQ	ETF	132.38	132.44	132.35	132.35	38802.0
2017-03-16 09:30:00	QQQ	ETF	132.34	132.35	132.11	132.18	2089753.0
2017-03-16 10:00:00	QQQ	ETF	132.18	132.26	131.96	132.07	1210302.0
2017-03-16 10:30:00	QQQ	ETF	132.07	132.08	131.94	132.02	712337.0
2017-03-16 11:00:00	QQQ	ETF	132.02	132.03	131.83	131.84	1004259.0
2017-03-16 11:30:00	QQQ	ETF	131.84	131.947	131.71	131.935	1129196.0
2017-03-16 12:00:00	QQQ	ETF	131.93	132.09	131.88	132.0646	630837.0
2017-03-16 12:30:00	QQQ	ETF	132.069	132.08	131.99	132.0253	299828.0
2017-03-16 13:00:00	QQQ	ETF	132.0201	132.0353	131.86	131.89	419030.0
2017-03-16 13:30:00	QQQ	ETF	131.885	131.99	131.86	131.93	1019328.0

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

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