PREVIEW / etf_30min / 2018-06-08

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-06-08.parquet
  size:    453 KB
  rows:    15,629

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-06-08 04:00:00	SPY	ETF	276.55	276.55	275.62	275.93	20193.0
2018-06-08 04:30:00	SPY	ETF	275.93	276.25	275.85	275.98	24654.0
2018-06-08 05:00:00	SPY	ETF	276.03	276.04	275.86	275.87	39679.0
2018-06-08 05:30:00	SPY	ETF	275.99	276.23	275.87	275.94	54713.0
2018-06-08 06:00:00	SPY	ETF	275.93	276.38	275.86	276.3	34472.0
2018-06-08 06:30:00	SPY	ETF	276.28	276.33	275.95	276.1	79470.0
2018-06-08 07:00:00	SPY	ETF	276.07	276.47	276.07	276.45	137035.0
2018-06-08 07:30:00	SPY	ETF	276.45	276.79	276.39	276.58	134160.0
2018-06-08 08:00:00	SPY	ETF	277.02	277.07	276.0	276.92	546403.0
2018-06-08 08:30:00	SPY	ETF	276.91	277.37	276.72	276.75	597308.0
2018-06-08 09:00:00	SPY	ETF	276.76	276.93	276.72	276.81	511714.0
2018-06-08 09:30:00	SPY	ETF	276.85	277.3116	276.66	277.29	6695082.0
2018-06-08 10:00:00	SPY	ETF	277.304	277.32	276.9099	277.0	3957872.0
2018-06-08 10:30:00	SPY	ETF	277.0	277.34	276.67	277.2	3874251.0
2018-06-08 11:00:00	SPY	ETF	277.19	277.42	276.94	277.225	4129069.0
2018-06-08 11:30:00	SPY	ETF	277.23	277.29	276.87	277.22	2162871.0
2018-06-08 12:00:00	SPY	ETF	277.225	277.855	277.21	277.84	2719734.0
2018-06-08 12:30:00	SPY	ETF	277.85	277.99	277.74	277.84	2692998.0
2018-06-08 13:00:00	SPY	ETF	277.85	277.86	277.63	277.82	1674221.0
2018-06-08 13:30:00	SPY	ETF	277.8275	277.9497	277.46	277.69	3077483.0
2018-06-08 14:00:00	SPY	ETF	277.7	278.06	277.67	277.9	1664015.0
2018-06-08 14:30:00	SPY	ETF	277.9	278.1	277.83	277.9	1962677.0
2018-06-08 15:00:00	SPY	ETF	277.9	278.04	277.69	278.0	2330824.0
2018-06-08 15:30:00	SPY	ETF	278.0	278.25	277.94	278.2	11777525.0
2018-06-08 16:00:00	SPY	ETF	278.19	278.3	278.09	278.19	17766961.0
2018-06-08 16:30:00	SPY	ETF	278.19	278.24	278.09	278.24	2264927.0
2018-06-08 17:00:00	SPY	ETF	278.21	278.33	278.12	278.32	334143.0
2018-06-08 17:30:00	SPY	ETF	278.33	278.35	278.21	278.21	33821.0
2018-06-08 18:00:00	SPY	ETF	278.21	278.29	278.18	278.29	49880.0
2018-06-08 18:30:00	SPY	ETF	278.3	278.39	278.26	278.27	64221.0
2018-06-08 19:00:00	SPY	ETF	278.32	278.39	278.31	278.39	2505.0
2018-06-08 19:30:00	SPY	ETF	278.37	278.42	278.31	278.42	12036.0
2018-06-08 04:00:00	QQQ	ETF	173.56	173.56	172.66	172.92	26619.0
2018-06-08 04:30:00	QQQ	ETF	172.9	173.2	172.8	173.05	6171.0
2018-06-08 05:00:00	QQQ	ETF	172.99	172.99	172.9	172.97	4400.0
2018-06-08 05:30:00	QQQ	ETF	173.07	173.13	172.8	172.88	10736.0
2018-06-08 06:00:00	QQQ	ETF	172.89	173.3	172.86	173.16	31550.0
2018-06-08 06:30:00	QQQ	ETF	173.16	173.16	172.75	172.85	72910.0
2018-06-08 07:00:00	QQQ	ETF	172.91	173.24	172.91	173.22	125684.0
2018-06-08 07:30:00	QQQ	ETF	173.23	173.42	173.15	173.29	165141.0
2018-06-08 08:00:00	QQQ	ETF	173.29	173.57	172.92	173.57	84931.0
2018-06-08 08:30:00	QQQ	ETF	173.57	173.69	173.42	173.45	116187.0
2018-06-08 09:00:00	QQQ	ETF	173.46	173.57	173.38	173.55	111781.0
2018-06-08 09:30:00	QQQ	ETF	173.53	173.99	173.42	173.97	4462546.0
2018-06-08 10:00:00	QQQ	ETF	173.98	174.06	173.59	173.61	3007649.0
2018-06-08 10:30:00	QQQ	ETF	173.609	173.86	173.18	173.8	1702556.0
2018-06-08 11:00:00	QQQ	ETF	173.8	174.24	173.645	174.0365	1663037.0
2018-06-08 11:30:00	QQQ	ETF	174.04	174.045	173.78	173.9673	1293193.0
2018-06-08 12:00:00	QQQ	ETF	173.96	174.36	173.96	174.35	878058.0
2018-06-08 12:30:00	QQQ	ETF	174.35	174.46	174.26	174.38	806213.0

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

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