PREVIEW / etf_30min / 2017-06-14

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-06-14.parquet
  size:    433 KB
  rows:    14,828

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-14 04:00:00	SPY	ETF	244.57	244.66	244.57	244.66	200.0
2017-06-14 04:30:00	SPY	ETF	244.59	244.59	244.59	244.59	100.0
2017-06-14 05:00:00	SPY	ETF	244.54	244.76	244.54	244.69	1345.0
2017-06-14 05:30:00	SPY	ETF	244.71	244.71	244.64	244.64	8400.0
2017-06-14 06:00:00	SPY	ETF	244.67	244.67	244.67	244.67	400.0
2017-06-14 06:30:00	SPY	ETF	244.67	244.79	244.63	244.78	50700.0
2017-06-14 07:00:00	SPY	ETF	244.76	244.84	244.76	244.8	63957.0
2017-06-14 07:30:00	SPY	ETF	244.82	244.93	244.7	244.79	265862.0
2017-06-14 08:00:00	SPY	ETF	244.79	244.82	244.38	244.7	328282.0
2017-06-14 08:30:00	SPY	ETF	244.67	245.02	244.55	244.82	474006.0
2017-06-14 09:00:00	SPY	ETF	244.81	244.97	244.737	244.85	482034.0
2017-06-14 09:30:00	SPY	ETF	244.86	244.87	244.31	244.56	5903479.0
2017-06-14 10:00:00	SPY	ETF	244.55	244.645	244.25	244.34	4369211.0
2017-06-14 10:30:00	SPY	ETF	244.34	244.44	243.965	244.13	3680637.0
2017-06-14 11:00:00	SPY	ETF	244.14	244.36	244.04	244.28	3173976.0
2017-06-14 11:30:00	SPY	ETF	244.28	244.35	244.08	244.34	2609008.0
2017-06-14 12:00:00	SPY	ETF	244.34	244.38	244.12	244.27	1880924.0
2017-06-14 12:30:00	SPY	ETF	244.27	244.48	244.26	244.32	1727498.0
2017-06-14 13:00:00	SPY	ETF	244.32	244.51	244.3	244.32	2498976.0
2017-06-14 13:30:00	SPY	ETF	244.33	244.4	244.21	244.29	4345337.0
2017-06-14 14:00:00	SPY	ETF	244.29	244.78	244.09	244.45	6535928.0
2017-06-14 14:30:00	SPY	ETF	244.44	244.55	243.56	243.71	9950491.0
2017-06-14 15:00:00	SPY	ETF	243.71	243.89	243.29	243.83	7866535.0
2017-06-14 15:30:00	SPY	ETF	243.83	244.41	243.64	244.26	12041149.0
2017-06-14 16:00:00	SPY	ETF	244.25	244.36	244.18	244.23	8913057.0
2017-06-14 16:30:00	SPY	ETF	244.23	244.31	244.09	244.13	160876.0
2017-06-14 17:00:00	SPY	ETF	244.17	244.2	244.13	244.13	28651.0
2017-06-14 17:30:00	SPY	ETF	244.13	244.19	243.4999	244.12	117298.0
2017-06-14 18:00:00	SPY	ETF	244.12	244.12	244.05	244.05	161678.0
2017-06-14 18:30:00	SPY	ETF	244.05	244.05	243.5	243.65	102187.0
2017-06-14 19:00:00	SPY	ETF	243.6	243.7	243.53	243.64	54337.0
2017-06-14 19:30:00	SPY	ETF	243.62	243.77	243.45	243.72	98168.0
2017-06-14 04:00:00	QQQ	ETF	140.45	140.57	140.39	140.57	500.0
2017-06-14 04:30:00	QQQ	ETF	140.49	140.49	140.49	140.49	100.0
2017-06-14 05:00:00	QQQ	ETF	140.5	140.58	140.5	140.58	3200.0
2017-06-14 05:30:00	QQQ	ETF	140.65	140.65	140.59	140.59	2900.0
2017-06-14 06:00:00	QQQ	ETF	140.59	140.61	140.56	140.59	3400.0
2017-06-14 06:30:00	QQQ	ETF	140.61	140.61	140.59	140.59	2000.0
2017-06-14 07:00:00	QQQ	ETF	140.62	140.71	140.62	140.71	13401.0
2017-06-14 07:30:00	QQQ	ETF	140.69	140.78	140.56	140.62	96580.0
2017-06-14 08:00:00	QQQ	ETF	140.63	140.73	140.55	140.56	135765.0
2017-06-14 08:30:00	QQQ	ETF	140.58	140.97	140.36	140.77	248690.0
2017-06-14 09:00:00	QQQ	ETF	140.8	141.05	140.77	140.9	223146.0
2017-06-14 09:30:00	QQQ	ETF	140.89	140.93	140.31	140.7	5328351.0
2017-06-14 10:00:00	QQQ	ETF	140.7	140.8	140.25	140.36	2662626.0
2017-06-14 10:30:00	QQQ	ETF	140.365	140.7	140.24	140.5	2951003.0
2017-06-14 11:00:00	QQQ	ETF	140.51	140.69	140.38	140.61	1808750.0
2017-06-14 11:30:00	QQQ	ETF	140.62	140.815	140.55	140.815	683054.0
2017-06-14 12:00:00	QQQ	ETF	140.81	140.85	140.41	140.56	1384706.0
2017-06-14 12:30:00	QQQ	ETF	140.56	140.72	140.5	140.51	1207050.0

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

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