PREVIEW / etf_30min / 2017-08-18

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-08-18.parquet
  size:    438 KB
  rows:    14,840

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-08-18 04:00:00	SPY	ETF	243.11	243.11	242.92	243.09	4460.0
2017-08-18 04:30:00	SPY	ETF	243.1	243.1	242.72	242.8	21712.0
2017-08-18 05:00:00	SPY	ETF	242.78	243.0	242.77	243.0	11000.0
2017-08-18 05:30:00	SPY	ETF	243.05	243.25	243.05	243.1	7053.0
2017-08-18 06:00:00	SPY	ETF	243.15	243.38	243.15	243.38	12840.0
2017-08-18 06:30:00	SPY	ETF	243.27	243.35	243.2	243.23	23038.0
2017-08-18 07:00:00	SPY	ETF	243.23	243.25	243.0	243.04	155567.0
2017-08-18 07:30:00	SPY	ETF	243.03	243.45	243.03	243.4	179761.0
2017-08-18 08:00:00	SPY	ETF	243.23	243.53	242.61	243.51	588978.0
2017-08-18 08:30:00	SPY	ETF	243.5	243.56	243.35	243.38	855281.0
2017-08-18 09:00:00	SPY	ETF	243.36	243.36	242.65	242.89	2808247.0
2017-08-18 09:30:00	SPY	ETF	242.9	242.99	242.2	242.21	15662218.0
2017-08-18 10:00:00	SPY	ETF	242.22	242.99	242.21	242.68	11941687.0
2017-08-18 10:30:00	SPY	ETF	242.68	242.88	242.42	242.7	14620490.0
2017-08-18 11:00:00	SPY	ETF	242.7	243.34	242.28	243.25	7838310.0
2017-08-18 11:30:00	SPY	ETF	243.24	243.76	243.12	243.58	7916105.0
2017-08-18 12:00:00	SPY	ETF	243.58	243.63	243.24	243.57	4565663.0
2017-08-18 12:30:00	SPY	ETF	243.58	244.189	243.505	243.8	8179512.0
2017-08-18 13:00:00	SPY	ETF	243.81	243.94	243.44	243.53	7656526.0
2017-08-18 13:30:00	SPY	ETF	243.53	243.65	243.08	243.1	4272417.0
2017-08-18 14:00:00	SPY	ETF	243.09	243.49	243.08	243.35	4438206.0
2017-08-18 14:30:00	SPY	ETF	243.36	243.48	243.143	243.19	3414003.0
2017-08-18 15:00:00	SPY	ETF	243.19	243.47	242.98	243.129	7848658.0
2017-08-18 15:30:00	SPY	ETF	243.13	243.3	242.63	242.69	14934453.0
2017-08-18 16:00:00	SPY	ETF	242.7	242.95	242.6757	242.87	14344016.0
2017-08-18 16:30:00	SPY	ETF	242.87	242.98	242.69	242.72	2941926.0
2017-08-18 17:00:00	SPY	ETF	242.72	242.8	242.65	242.65	268784.0
2017-08-18 17:30:00	SPY	ETF	242.66	242.69	242.59	242.6	41223.0
2017-08-18 18:00:00	SPY	ETF	242.59	242.59	242.51	242.53	29132.0
2017-08-18 18:30:00	SPY	ETF	242.56	242.61	242.48	242.52	25566.0
2017-08-18 19:00:00	SPY	ETF	242.59	242.66	242.53	242.56	4795.0
2017-08-18 19:30:00	SPY	ETF	242.64	242.64	242.53	242.58	10481.0
2017-08-18 04:00:00	QQQ	ETF	141.37	141.38	141.2	141.29	2304.0
2017-08-18 04:30:00	QQQ	ETF	141.17	141.18	141.14	141.18	1600.0
2017-08-18 05:00:00	QQQ	ETF	141.32	141.36	141.32	141.36	5841.0
2017-08-18 05:30:00	QQQ	ETF	141.47	141.61	141.45	141.5	27303.0
2017-08-18 06:00:00	QQQ	ETF	141.47	141.69	141.47	141.66	19929.0
2017-08-18 06:30:00	QQQ	ETF	141.7	141.74	141.66	141.72	10381.0
2017-08-18 07:00:00	QQQ	ETF	141.74	141.76	141.63	141.65	65530.0
2017-08-18 07:30:00	QQQ	ETF	141.64	141.82	141.61	141.8	46440.0
2017-08-18 08:00:00	QQQ	ETF	141.75	141.93	141.73	141.92	137879.0
2017-08-18 08:30:00	QQQ	ETF	141.9	141.97	141.8	141.88	70261.0
2017-08-18 09:00:00	QQQ	ETF	141.86	141.87	141.33	141.37	548325.0
2017-08-18 09:30:00	QQQ	ETF	141.42	141.57	140.65	140.67	10041816.0
2017-08-18 10:00:00	QQQ	ETF	140.68	141.5449	140.67	141.36	4349006.0
2017-08-18 10:30:00	QQQ	ETF	141.36	141.61	141.1	141.41	3439403.0
2017-08-18 11:00:00	QQQ	ETF	141.4135	141.81	140.99	141.7852	3357527.0
2017-08-18 11:30:00	QQQ	ETF	141.78	142.09	141.64	141.97	2467928.0
2017-08-18 12:00:00	QQQ	ETF	141.97	141.995	141.66	141.9399	2026709.0
2017-08-18 12:30:00	QQQ	ETF	141.9335	142.2	141.84	142.0	3215769.0

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

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