PREVIEW / etf_30min / 2017-11-03

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-11-03.parquet
  size:    442 KB
  rows:    15,260

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-11-03 04:00:00	SPY	ETF	257.66	257.67	257.61	257.65	6300.0
2017-11-03 04:30:00	SPY	ETF	257.65	257.72	257.65	257.72	2300.0
2017-11-03 05:00:00	SPY	ETF	257.79	257.79	257.79	257.79	300.0
2017-11-03 05:30:00	SPY	ETF	257.83	257.83	257.83	257.83	500.0
2017-11-03 06:00:00	SPY	ETF	257.81	257.81	257.81	257.81	1040.0
2017-11-03 06:30:00	SPY	ETF	257.87	257.9	257.87	257.9	2759.0
2017-11-03 07:00:00	SPY	ETF	257.84	257.85	257.83	257.83	3360.0
2017-11-03 07:30:00	SPY	ETF	257.84	257.86	257.8	257.8	13095.0
2017-11-03 08:00:00	SPY	ETF	257.59	257.82	257.59	257.82	54977.0
2017-11-03 08:30:00	SPY	ETF	257.75	258.06	257.68	257.8	219973.0
2017-11-03 09:00:00	SPY	ETF	257.74	257.9	257.72	257.78	110289.0
2017-11-03 09:30:00	SPY	ETF	257.77	257.86	257.3	257.49	7114490.0
2017-11-03 10:00:00	SPY	ETF	257.49	257.72	257.38	257.49	3366766.0
2017-11-03 10:30:00	SPY	ETF	257.5	257.63	257.39	257.625	1632237.0
2017-11-03 11:00:00	SPY	ETF	257.63	257.855	257.57	257.83	2112671.0
2017-11-03 11:30:00	SPY	ETF	257.83	257.99	257.73	257.94	2219606.0
2017-11-03 12:00:00	SPY	ETF	257.945	258.18	257.94	258.125	3375419.0
2017-11-03 12:30:00	SPY	ETF	258.13	258.21	258.08	258.13	2137409.0
2017-11-03 13:00:00	SPY	ETF	258.1311	258.305	258.13	258.2441	1830596.0
2017-11-03 13:30:00	SPY	ETF	258.245	258.38	258.23	258.365	2585945.0
2017-11-03 14:00:00	SPY	ETF	258.36	258.5	258.33	258.47	2758962.0
2017-11-03 14:30:00	SPY	ETF	258.47	258.4899	258.25	258.4	1980166.0
2017-11-03 15:00:00	SPY	ETF	258.405	258.45	258.26	258.3397	2930405.0
2017-11-03 15:30:00	SPY	ETF	258.33	258.45	258.23	258.44	9491706.0
2017-11-03 16:00:00	SPY	ETF	258.44	258.46	258.21	258.24	8746913.0
2017-11-03 16:30:00	SPY	ETF	258.24	258.45	258.11	258.11	4430934.0
2017-11-03 17:00:00	SPY	ETF	258.15	258.405	258.14	258.2	83890.0
2017-11-03 17:30:00	SPY	ETF	258.18	258.3	258.17	258.24	67479.0
2017-11-03 18:00:00	SPY	ETF	258.2	258.26	258.18	258.26	26234.0
2017-11-03 18:30:00	SPY	ETF	258.25	258.25	258.25	258.25	582.0
2017-11-03 19:00:00	SPY	ETF	258.22	258.22	258.2	258.2	2400.0
2017-11-03 19:30:00	SPY	ETF	258.21	258.24	258.21	258.21	8975.0
2017-11-03 04:00:00	QQQ	ETF	152.19	152.23	152.09	152.09	20200.0
2017-11-03 04:30:00	QQQ	ETF	152.25	152.26	152.25	152.26	15700.0
2017-11-03 05:00:00	QQQ	ETF	152.3	152.3	152.3	152.3	100.0
2017-11-03 06:00:00	QQQ	ETF	152.32	152.32	152.32	152.32	100.0
2017-11-03 06:30:00	QQQ	ETF	152.38	152.38	152.38	152.38	400.0
2017-11-03 07:00:00	QQQ	ETF	152.42	152.45	152.42	152.42	1350.0
2017-11-03 07:30:00	QQQ	ETF	152.4	152.41	152.38	152.39	8870.0
2017-11-03 08:00:00	QQQ	ETF	152.38	152.42	152.32	152.4	55420.0
2017-11-03 08:30:00	QQQ	ETF	152.43	152.76	152.43	152.55	161001.0
2017-11-03 09:00:00	QQQ	ETF	152.49	152.58	152.39	152.39	243145.0
2017-11-03 09:30:00	QQQ	ETF	152.4	152.52	151.9	152.03	2472438.0
2017-11-03 10:00:00	QQQ	ETF	152.03	152.25	151.84	152.03	1342172.0
2017-11-03 10:30:00	QQQ	ETF	152.03	152.33	151.97	152.32	904902.0
2017-11-03 11:00:00	QQQ	ETF	152.31	152.38	152.19	152.36	798612.0
2017-11-03 11:30:00	QQQ	ETF	152.36	152.61	152.26	152.58	841289.0
2017-11-03 12:00:00	QQQ	ETF	152.58	152.76	152.56	152.69	1028495.0
2017-11-03 12:30:00	QQQ	ETF	152.6948	152.73	152.595	152.68	485165.0
2017-11-03 13:00:00	QQQ	ETF	152.68	152.9	152.68	152.88	595157.0

> showing 50 of 15,260 rows — these rows as CSV

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