PREVIEW / etf_30min / 2018-07-26

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-07-26.parquet
  size:    462 KB
  rows:    16,075

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-07-26 04:00:00	SPY	ETF	283.02	283.07	282.94	282.94	4116.0
2018-07-26 04:30:00	SPY	ETF	283.05	283.07	282.89	282.96	12783.0
2018-07-26 05:00:00	SPY	ETF	282.96	283.1	282.96	283.06	9776.0
2018-07-26 05:30:00	SPY	ETF	283.16	283.23	283.05	283.18	14532.0
2018-07-26 06:00:00	SPY	ETF	283.15	283.18	282.97	283.01	12509.0
2018-07-26 06:30:00	SPY	ETF	282.99	283.04	282.93	282.99	112277.0
2018-07-26 07:00:00	SPY	ETF	283.0	283.16	282.98	283.12	122188.0
2018-07-26 07:30:00	SPY	ETF	283.1	283.19	283.06	283.1	176249.0
2018-07-26 08:00:00	SPY	ETF	283.1001	283.34	282.85	283.1	551831.0
2018-07-26 08:30:00	SPY	ETF	283.1	283.22	283.0	283.04	252031.0
2018-07-26 09:00:00	SPY	ETF	283.02	283.25	282.9534	283.18	650274.0
2018-07-26 09:30:00	SPY	ETF	283.2	283.84	283.09	283.42	8109973.0
2018-07-26 10:00:00	SPY	ETF	283.42	283.77	283.36	283.37	4058051.0
2018-07-26 10:30:00	SPY	ETF	283.36	283.84	283.32	283.8251	2615923.0
2018-07-26 11:00:00	SPY	ETF	283.83	283.96	283.71	283.77	2302438.0
2018-07-26 11:30:00	SPY	ETF	283.77	283.92	283.54	283.91	1963803.0
2018-07-26 12:00:00	SPY	ETF	283.92	284.11	283.46	283.515	2887403.0
2018-07-26 12:30:00	SPY	ETF	283.52	283.59	283.19	283.26	2365954.0
2018-07-26 13:00:00	SPY	ETF	283.26	283.66	283.1415	283.56	2109562.0
2018-07-26 13:30:00	SPY	ETF	283.56	283.57	283.305	283.4	2682301.0
2018-07-26 14:00:00	SPY	ETF	283.39	283.525	283.245	283.52	2036134.0
2018-07-26 14:30:00	SPY	ETF	283.51	283.62	283.37	283.38	2284862.0
2018-07-26 15:00:00	SPY	ETF	283.39	283.4	283.12	283.3	5051787.0
2018-07-26 15:30:00	SPY	ETF	283.3	283.49	283.125	283.29	6922908.0
2018-07-26 16:00:00	SPY	ETF	283.29	283.77	282.82	283.64	9091002.0
2018-07-26 16:30:00	SPY	ETF	283.65	283.66	283.44	283.47	304755.0
2018-07-26 17:00:00	SPY	ETF	283.45	283.57	283.45	283.54	17367.0
2018-07-26 17:30:00	SPY	ETF	283.5	283.64	283.34	283.52	109393.0
2018-07-26 18:00:00	SPY	ETF	283.51	283.64	283.43	283.55	38652.0
2018-07-26 18:30:00	SPY	ETF	283.55	283.58	283.5	283.55	9347.0
2018-07-26 19:00:00	SPY	ETF	283.6	283.69	283.57	283.65	8379.0
2018-07-26 19:30:00	SPY	ETF	283.65	283.73	283.2745	283.73	52408.0
2018-07-26 04:00:00	QQQ	ETF	180.15	180.15	179.83	180.02	13078.0
2018-07-26 04:30:00	QQQ	ETF	179.98	180.04	179.87	179.96	22950.0
2018-07-26 05:00:00	QQQ	ETF	179.89	180.08	179.79	179.99	31880.0
2018-07-26 05:30:00	QQQ	ETF	180.08	180.18	180.04	180.11	33177.0
2018-07-26 06:00:00	QQQ	ETF	180.11	180.14	179.96	179.99	28038.0
2018-07-26 06:30:00	QQQ	ETF	179.97	180.03	179.96	180.0	30250.0
2018-07-26 07:00:00	QQQ	ETF	180.02	180.25	180.0	180.1	90827.0
2018-07-26 07:30:00	QQQ	ETF	180.15	180.4	180.15	180.3	77741.0
2018-07-26 08:00:00	QQQ	ETF	180.14	180.57	179.8	180.43	216378.0
2018-07-26 08:30:00	QQQ	ETF	180.41	180.41	180.06	180.12	477401.0
2018-07-26 09:00:00	QQQ	ETF	180.13	180.39	180.0	180.33	514782.0
2018-07-26 09:30:00	QQQ	ETF	180.35	180.86	179.81	180.21	6956525.0
2018-07-26 10:00:00	QQQ	ETF	180.205	180.795	180.14	180.32	3610643.0
2018-07-26 10:30:00	QQQ	ETF	180.325	180.67	180.2	180.6	2493508.0
2018-07-26 11:00:00	QQQ	ETF	180.605	180.9	180.51	180.8	1836405.0
2018-07-26 11:30:00	QQQ	ETF	180.79	180.87	180.4555	180.87	1269449.0
2018-07-26 12:00:00	QQQ	ETF	180.87	180.92	180.335	180.445	1224577.0
2018-07-26 12:30:00	QQQ	ETF	180.45	180.5	180.01	180.1439	868491.0

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

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