PREVIEW / etf_30min / 2018-11-19

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-11-19.parquet
  size:    492 KB
  rows:    16,980

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-19 04:00:00	SPY	ETF	274.32	274.32	273.87	274.28	11602.0
2018-11-19 04:30:00	SPY	ETF	274.3	274.3	273.75	273.93	14796.0
2018-11-19 05:00:00	SPY	ETF	273.9	274.08	273.71	273.88	17260.0
2018-11-19 05:30:00	SPY	ETF	273.85	273.85	273.48	273.65	40185.0
2018-11-19 06:00:00	SPY	ETF	273.8	273.94	273.57	273.57	19352.0
2018-11-19 06:30:00	SPY	ETF	273.57	273.59	273.16	273.2	82837.0
2018-11-19 07:00:00	SPY	ETF	273.23	273.34	272.96	273.22	147210.0
2018-11-19 07:30:00	SPY	ETF	273.28	273.36	273.14	273.3	121000.0
2018-11-19 08:00:00	SPY	ETF	273.1501	274.0	273.01	273.6	236991.0
2018-11-19 08:30:00	SPY	ETF	273.61	273.62	272.97	273.12	226695.0
2018-11-19 09:00:00	SPY	ETF	273.11	273.16	272.73	273.06	486091.0
2018-11-19 09:30:00	SPY	ETF	273.05	273.38	272.12	272.545	6784854.0
2018-11-19 10:00:00	SPY	ETF	272.53	272.55	270.92	271.2875	6139543.0
2018-11-19 10:30:00	SPY	ETF	271.29	271.88	270.55	271.588	5356836.0
2018-11-19 11:00:00	SPY	ETF	271.585	271.79	270.42	270.61	3866273.0
2018-11-19 11:30:00	SPY	ETF	270.6	270.67	269.08	269.51	6344536.0
2018-11-19 12:00:00	SPY	ETF	269.505	269.7	268.57	269.22	7367577.0
2018-11-19 12:30:00	SPY	ETF	269.21	269.76	268.68	269.54	4725928.0
2018-11-19 13:00:00	SPY	ETF	269.54	269.64	268.58	268.85	4574820.0
2018-11-19 13:30:00	SPY	ETF	268.85	269.76	268.3	268.71	6348051.0
2018-11-19 14:00:00	SPY	ETF	268.72	269.38	268.07	268.82	8030899.0
2018-11-19 14:30:00	SPY	ETF	268.81	269.66	268.34	269.465	6737505.0
2018-11-19 15:00:00	SPY	ETF	269.455	270.25	269.02	269.59	6791908.0
2018-11-19 15:30:00	SPY	ETF	269.6	269.73	268.31	269.12	13479284.0
2018-11-19 16:00:00	SPY	ETF	269.12	269.62	269.0774	269.5601	11332865.0
2018-11-19 16:30:00	SPY	ETF	269.55	269.63	269.0772	269.63	1556745.0
2018-11-19 17:00:00	SPY	ETF	269.63	269.64	269.52	269.54	92281.0
2018-11-19 17:30:00	SPY	ETF	269.54	269.58	269.1	269.43	215435.0
2018-11-19 18:00:00	SPY	ETF	269.47	269.53	268.91	269.11	102068.0
2018-11-19 18:30:00	SPY	ETF	269.12	269.42	269.04	269.1	78506.0
2018-11-19 19:00:00	SPY	ETF	269.08	269.27	268.77	269.27	96549.0
2018-11-19 19:30:00	SPY	ETF	269.2	269.2	268.84	268.96	28024.0
2018-11-19 20:00:00	SPY	ETF	269.1	269.1	268.81	268.81	1000.0
2018-11-19 04:00:00	QQQ	ETF	168.58	168.58	168.14	168.44	22018.0
2018-11-19 04:30:00	QQQ	ETF	168.38	168.38	168.0	168.08	13297.0
2018-11-19 05:00:00	QQQ	ETF	168.09	168.18	167.9	167.99	16803.0
2018-11-19 05:30:00	QQQ	ETF	167.97	167.97	167.7	167.8	40518.0
2018-11-19 06:00:00	QQQ	ETF	167.94	168.02	167.55	167.62	34049.0
2018-11-19 06:30:00	QQQ	ETF	167.58	167.59	167.21	167.26	87881.0
2018-11-19 07:00:00	QQQ	ETF	167.35	167.44	167.08	167.37	96629.0
2018-11-19 07:30:00	QQQ	ETF	167.43	167.46	167.26	167.3	108299.0
2018-11-19 08:00:00	QQQ	ETF	167.3001	168.74	167.16	167.44	218317.0
2018-11-19 08:30:00	QQQ	ETF	167.43	167.43	166.71	166.82	155515.0
2018-11-19 09:00:00	QQQ	ETF	166.82	166.95	166.42	166.73	425051.0
2018-11-19 09:30:00	QQQ	ETF	166.73	166.9	165.07	165.49	5352848.0
2018-11-19 10:00:00	QQQ	ETF	165.48	165.5	164.04	164.3316	5283730.0
2018-11-19 10:30:00	QQQ	ETF	164.33	165.05	163.74	164.78	5226188.0
2018-11-19 11:00:00	QQQ	ETF	164.76	164.96	163.53	163.8	1984244.0
2018-11-19 11:30:00	QQQ	ETF	163.76	163.77	162.68	163.09	4290793.0
2018-11-19 12:00:00	QQQ	ETF	163.05	163.25	162.45	162.94	3698178.0

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

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