PREVIEW / etf_30min / 2018-11-12

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-11-12.parquet
  size:    487 KB
  rows:    16,882

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-12 04:00:00	SPY	ETF	277.42	277.99	277.42	277.82	11174.0
2018-11-12 04:30:00	SPY	ETF	277.9	277.91	277.5	277.78	11418.0
2018-11-12 05:00:00	SPY	ETF	277.63	277.74	277.39	277.69	17300.0
2018-11-12 05:30:00	SPY	ETF	277.68	277.97	277.51	277.75	14259.0
2018-11-12 06:00:00	SPY	ETF	277.74	277.79	277.36	277.44	9355.0
2018-11-12 06:30:00	SPY	ETF	277.35	277.44	277.31	277.42	21440.0
2018-11-12 07:00:00	SPY	ETF	277.39	277.58	277.38	277.48	82709.0
2018-11-12 07:30:00	SPY	ETF	277.51	277.71	277.18	277.26	76671.0
2018-11-12 08:00:00	SPY	ETF	277.5618	278.83	276.62	276.81	364130.0
2018-11-12 08:30:00	SPY	ETF	276.83	277.19	276.82	277.13	208991.0
2018-11-12 09:00:00	SPY	ETF	277.16	277.38	276.92	277.18	330242.0
2018-11-12 09:30:00	SPY	ETF	277.19	277.46	275.55	275.61	7698661.0
2018-11-12 10:00:00	SPY	ETF	275.6101	275.94	275.11	275.77	6003574.0
2018-11-12 10:30:00	SPY	ETF	275.78	275.79	274.42	274.49	6775484.0
2018-11-12 11:00:00	SPY	ETF	274.49	274.57	273.31	273.335	6302738.0
2018-11-12 11:30:00	SPY	ETF	273.33	274.18	273.01	274.08	6915445.0
2018-11-12 12:00:00	SPY	ETF	274.07	274.64	273.97	274.22	4384209.0
2018-11-12 12:30:00	SPY	ETF	274.22	274.37	273.69	273.69	2758836.0
2018-11-12 13:00:00	SPY	ETF	273.69	273.93	273.16	273.7	3698100.0
2018-11-12 13:30:00	SPY	ETF	273.7	274.3644	273.01	273.97	4459080.0
2018-11-12 14:00:00	SPY	ETF	273.96	274.94	273.81	274.14	4926962.0
2018-11-12 14:30:00	SPY	ETF	274.1385	274.81	273.6	273.67	4821479.0
2018-11-12 15:00:00	SPY	ETF	273.67	274.16	272.9	273.75	7878553.0
2018-11-12 15:30:00	SPY	ETF	273.75	273.75	271.99	272.49	20166902.0
2018-11-12 16:00:00	SPY	ETF	272.54	273.05	272.4153	272.65	7796482.0
2018-11-12 16:30:00	SPY	ETF	272.66	272.96	272.45	272.8	349736.0
2018-11-12 17:00:00	SPY	ETF	272.8	272.88	272.57	272.72	921756.0
2018-11-12 17:30:00	SPY	ETF	272.7	272.92	272.57	272.88	41487.0
2018-11-12 18:00:00	SPY	ETF	272.91	273.28	272.86	273.23	165004.0
2018-11-12 18:30:00	SPY	ETF	273.19	273.29	272.55	272.66	78288.0
2018-11-12 19:00:00	SPY	ETF	272.67	272.86	272.12	272.32	218436.0
2018-11-12 19:30:00	SPY	ETF	272.28	272.39	271.85	272.04	48055.0
2018-11-12 04:00:00	QQQ	ETF	171.5	171.93	171.5	171.89	4778.0
2018-11-12 04:30:00	QQQ	ETF	171.79	171.79	171.62	171.68	7450.0
2018-11-12 05:00:00	QQQ	ETF	171.68	171.72	171.29	171.53	3000.0
2018-11-12 05:30:00	QQQ	ETF	171.77	171.88	171.73	171.8	9916.0
2018-11-12 06:00:00	QQQ	ETF	171.7	171.7	171.19	171.19	5457.0
2018-11-12 06:30:00	QQQ	ETF	171.25	171.34	171.25	171.31	6623.0
2018-11-12 07:00:00	QQQ	ETF	171.27	171.44	171.21	171.26	47804.0
2018-11-12 07:30:00	QQQ	ETF	171.32	171.5	171.01	171.08	54431.0
2018-11-12 08:00:00	QQQ	ETF	171.08	172.41	170.09	170.1	501546.0
2018-11-12 08:30:00	QQQ	ETF	170.15	170.35	170.12	170.35	368161.0
2018-11-12 09:00:00	QQQ	ETF	170.35	170.58	170.12	170.3	284324.0
2018-11-12 09:30:00	QQQ	ETF	170.29	170.64	168.58	168.72	6451810.0
2018-11-12 10:00:00	QQQ	ETF	168.72	168.91	168.19	168.67	3952478.0
2018-11-12 10:30:00	QQQ	ETF	168.67	168.67	167.29	167.36	3829151.0
2018-11-12 11:00:00	QQQ	ETF	167.37	167.39	166.23	166.36	4903441.0
2018-11-12 11:30:00	QQQ	ETF	166.35	167.3368	166.18	167.28	4091854.0
2018-11-12 12:00:00	QQQ	ETF	167.2819	167.95	167.265	167.47	3691357.0
2018-11-12 12:30:00	QQQ	ETF	167.47	167.63	167.13	167.15	1549782.0

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

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