PREVIEW / etf_30min / 2018-11-09

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-11-09.parquet
  size:    485 KB
  rows:    16,803

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
2018-11-09 04:00:00	SPY	ETF	279.38	279.63	279.27	279.39	36020.0
2018-11-09 04:30:00	SPY	ETF	279.41	279.5	279.08	279.5	14810.0
2018-11-09 05:00:00	SPY	ETF	279.5	279.54	279.25	279.34	26833.0
2018-11-09 05:30:00	SPY	ETF	279.27	279.31	278.82	278.98	76878.0
2018-11-09 06:00:00	SPY	ETF	278.93	279.19	278.89	279.11	28047.0
2018-11-09 06:30:00	SPY	ETF	279.14	279.14	278.69	279.05	104776.0
2018-11-09 07:00:00	SPY	ETF	279.04	279.22	278.85	278.85	77616.0
2018-11-09 07:30:00	SPY	ETF	278.87	279.32	278.85	279.31	110141.0
2018-11-09 08:00:00	SPY	ETF	279.31	280.55	278.92	279.39	159964.0
2018-11-09 08:30:00	SPY	ETF	279.34	279.35	278.91	279.19	416328.0
2018-11-09 09:00:00	SPY	ETF	279.18	279.3	278.98	279.03	323919.0
2018-11-09 09:30:00	SPY	ETF	279.03	279.24	278.11	278.43	8150324.0
2018-11-09 10:00:00	SPY	ETF	278.4301	278.66	277.53	278.3485	7006588.0
2018-11-09 10:30:00	SPY	ETF	278.35	278.59	277.75	277.96	4334499.0
2018-11-09 11:00:00	SPY	ETF	277.97	278.31	277.45	278.0479	3997719.0
2018-11-09 11:30:00	SPY	ETF	278.04	278.31	276.98	277.14	5632269.0
2018-11-09 12:00:00	SPY	ETF	277.14	277.5729	276.81	277.16	5129015.0
2018-11-09 12:30:00	SPY	ETF	277.17	277.76	277.03	277.285	3363251.0
2018-11-09 13:00:00	SPY	ETF	277.29	277.445	276.89	277.12	3538702.0
2018-11-09 13:30:00	SPY	ETF	277.12	277.1201	276.52	276.74	4002739.0
2018-11-09 14:00:00	SPY	ETF	276.73	277.11	276.18	276.325	4797224.0
2018-11-09 14:30:00	SPY	ETF	276.325	277.99	276.32	277.5699	7914203.0
2018-11-09 15:00:00	SPY	ETF	277.565	278.555	277.41	278.27	8710391.0
2018-11-09 15:30:00	SPY	ETF	278.26	278.83	277.81	277.83	15580614.0
2018-11-09 16:00:00	SPY	ETF	277.82	277.95	277.4	277.55	12527929.0
2018-11-09 16:30:00	SPY	ETF	277.55	277.68	277.47	277.59	377207.0
2018-11-09 17:00:00	SPY	ETF	277.5	277.58	277.35	277.43	198332.0
2018-11-09 17:30:00	SPY	ETF	277.42	277.5	277.3	277.5	37933.0
2018-11-09 18:00:00	SPY	ETF	277.44	277.48	277.25	277.26	19866.0
2018-11-09 18:30:00	SPY	ETF	277.26	277.37	277.21	277.35	5664.0
2018-11-09 19:00:00	SPY	ETF	277.33	277.33	277.26	277.26	3962.0
2018-11-09 19:30:00	SPY	ETF	277.26	277.3	277.1	277.14	15285.0
2018-11-09 04:00:00	QQQ	ETF	173.34	173.53	173.34	173.43	2428.0
2018-11-09 04:30:00	QQQ	ETF	173.41	173.46	173.22	173.46	5975.0
2018-11-09 05:00:00	QQQ	ETF	173.46	173.5	173.3	173.37	5900.0
2018-11-09 05:30:00	QQQ	ETF	173.38	173.38	172.99	173.03	32525.0
2018-11-09 06:00:00	QQQ	ETF	173.03	173.18	172.98	173.13	23600.0
2018-11-09 06:30:00	QQQ	ETF	173.13	173.13	172.73	173.0	49886.0
2018-11-09 07:00:00	QQQ	ETF	173.0	173.12	172.8	172.81	114930.0
2018-11-09 07:30:00	QQQ	ETF	172.8	173.16	172.8	173.12	80433.0
2018-11-09 08:00:00	QQQ	ETF	173.05	173.3	172.81	173.19	72663.0
2018-11-09 08:30:00	QQQ	ETF	173.18	173.18	172.83	173.07	200247.0
2018-11-09 09:00:00	QQQ	ETF	173.05	173.11	172.8	172.85	232837.0
2018-11-09 09:30:00	QQQ	ETF	172.83	173.25	172.1	172.47	5380157.0
2018-11-09 10:00:00	QQQ	ETF	172.47	172.729	171.57	171.99	4297587.0
2018-11-09 10:30:00	QQQ	ETF	172.01	172.42	171.67	171.83	2496377.0
2018-11-09 11:00:00	QQQ	ETF	171.83	172.0901	171.35	171.66	2431132.0
2018-11-09 11:30:00	QQQ	ETF	171.64	171.86	170.93	171.02	2592883.0
2018-11-09 12:00:00	QQQ	ETF	171.0198	171.35	170.7999	170.99	2272810.0
2018-11-09 12:30:00	QQQ	ETF	170.99	171.4	170.89	171.065	1574856.0

> showing 50 of 16,803 rows — these rows as CSV

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