PREVIEW / etf_30min / 2018-05-22

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-05-22.parquet
  size:    457 KB
  rows:    15,776

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-05-22 04:00:00	SPY	ETF	273.7	273.8	273.7	273.8	12479.0
2018-05-22 04:30:00	SPY	ETF	273.77	273.82	273.77	273.82	2838.0
2018-05-22 05:00:00	SPY	ETF	273.85	273.92	273.85	273.92	2250.0
2018-05-22 05:30:00	SPY	ETF	273.81	273.94	273.8	273.88	2965.0
2018-05-22 06:00:00	SPY	ETF	273.93	273.99	273.9	273.9	4715.0
2018-05-22 06:30:00	SPY	ETF	273.87	273.89	273.73	273.86	16060.0
2018-05-22 07:00:00	SPY	ETF	273.9	273.95	273.81	273.81	33738.0
2018-05-22 07:30:00	SPY	ETF	273.8	273.9	273.79	273.9	41193.0
2018-05-22 08:00:00	SPY	ETF	273.9	273.96	273.389	273.95	142521.0
2018-05-22 08:30:00	SPY	ETF	273.94	273.94	273.76	273.81	158325.0
2018-05-22 09:00:00	SPY	ETF	273.79	273.97	273.75	273.96	136879.0
2018-05-22 09:30:00	SPY	ETF	273.96	274.25	273.7599	273.94	4870726.0
2018-05-22 10:00:00	SPY	ETF	273.94	274.18	273.39	273.51	4140650.0
2018-05-22 10:30:00	SPY	ETF	273.52	273.8	273.34	273.57	3273292.0
2018-05-22 11:00:00	SPY	ETF	273.56	273.99	273.56	273.87	1886094.0
2018-05-22 11:30:00	SPY	ETF	273.87	273.92	273.64	273.7851	1968803.0
2018-05-22 12:00:00	SPY	ETF	273.79	273.915	273.49	273.62	2306299.0
2018-05-22 12:30:00	SPY	ETF	273.62	273.695	273.44	273.5695	2108312.0
2018-05-22 13:00:00	SPY	ETF	273.58	273.69	273.44	273.6	1286326.0
2018-05-22 13:30:00	SPY	ETF	273.59	273.62	273.4	273.51	1588043.0
2018-05-22 14:00:00	SPY	ETF	273.52	273.75	273.481	273.695	1424161.0
2018-05-22 14:30:00	SPY	ETF	273.69	273.85	273.19	273.191	2973831.0
2018-05-22 15:00:00	SPY	ETF	273.2	273.31	272.94	273.04	4018985.0
2018-05-22 15:30:00	SPY	ETF	273.03	273.04	272.24	272.56	12763893.0
2018-05-22 16:00:00	SPY	ETF	272.57	272.82	272.4978	272.69	5841216.0
2018-05-22 16:30:00	SPY	ETF	272.69	272.78	272.62	272.65	69801.0
2018-05-22 17:00:00	SPY	ETF	273.3513	273.3513	272.54	272.54	2838851.0
2018-05-22 17:30:00	SPY	ETF	272.54	272.62	272.52	272.6	37095.0
2018-05-22 18:00:00	SPY	ETF	272.6	272.67	272.52	272.6	47706.0
2018-05-22 18:30:00	SPY	ETF	272.6	272.68	272.6	272.68	4931.0
2018-05-22 19:00:00	SPY	ETF	272.65	272.66	272.61	272.65	8504.0
2018-05-22 19:30:00	SPY	ETF	272.63	272.63	272.5	272.52	10255.0
2018-05-22 04:00:00	QQQ	ETF	168.65	168.83	168.65	168.78	2500.0
2018-05-22 04:30:00	QQQ	ETF	168.72	168.83	168.72	168.83	660.0
2018-05-22 05:00:00	QQQ	ETF	168.94	169.04	168.94	169.03	5400.0
2018-05-22 05:30:00	QQQ	ETF	169.03	169.06	169.02	169.04	1400.0
2018-05-22 06:00:00	QQQ	ETF	169.13	169.2	169.13	169.17	6475.0
2018-05-22 06:30:00	QQQ	ETF	169.17	169.25	169.05	169.25	12070.0
2018-05-22 07:00:00	QQQ	ETF	169.25	169.26	169.09	169.09	62565.0
2018-05-22 07:30:00	QQQ	ETF	169.04	169.06	168.98	169.02	136888.0
2018-05-22 08:00:00	QQQ	ETF	169.1999	169.23	169.0	169.1	54641.0
2018-05-22 08:30:00	QQQ	ETF	169.05	169.06	168.98	169.01	44400.0
2018-05-22 09:00:00	QQQ	ETF	169.0	169.17	168.97	169.13	95941.0
2018-05-22 09:30:00	QQQ	ETF	169.14	169.45	168.87	168.99	2112607.0
2018-05-22 10:00:00	QQQ	ETF	168.995	169.05	168.28	168.35	1883914.0
2018-05-22 10:30:00	QQQ	ETF	168.37	168.75	168.2801	168.56	1833562.0
2018-05-22 11:00:00	QQQ	ETF	168.5401	168.79	168.51	168.62	632119.0
2018-05-22 11:30:00	QQQ	ETF	168.63	168.67	168.34	168.519	934834.0
2018-05-22 12:00:00	QQQ	ETF	168.53	168.69	168.29	168.36	719783.0
2018-05-22 12:30:00	QQQ	ETF	168.36	168.47	168.141	168.3751	961136.0

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

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