PREVIEW / etf_30min / 2018-09-28

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-09-28.parquet
  size:    469 KB
  rows:    16,258

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-09-28 04:00:00	SPY	ETF	290.41	290.69	290.41	290.66	4802.0
2018-09-28 04:30:00	SPY	ETF	290.76	290.86	290.76	290.81	3530.0
2018-09-28 05:00:00	SPY	ETF	290.81	290.81	290.58	290.58	9050.0
2018-09-28 05:30:00	SPY	ETF	290.54	290.54	290.43	290.46	5800.0
2018-09-28 06:00:00	SPY	ETF	290.46	290.46	289.99	290.09	18428.0
2018-09-28 06:30:00	SPY	ETF	290.11	290.32	290.02	290.14	25150.0
2018-09-28 07:00:00	SPY	ETF	290.17	290.17	289.87	289.92	174392.0
2018-09-28 07:30:00	SPY	ETF	289.93	289.95	289.6	289.63	163137.0
2018-09-28 08:00:00	SPY	ETF	290.69	291.0	289.54	289.84	541444.0
2018-09-28 08:30:00	SPY	ETF	289.86	290.03	289.77	289.98	283283.0
2018-09-28 09:00:00	SPY	ETF	289.95	290.09	289.8	289.96	700333.0
2018-09-28 09:30:00	SPY	ETF	289.99	290.42	289.95	290.38	5919247.0
2018-09-28 10:00:00	SPY	ETF	290.3701	290.69	290.18	290.67	3535223.0
2018-09-28 10:30:00	SPY	ETF	290.66	291.105	290.5599	291.0	2976782.0
2018-09-28 11:00:00	SPY	ETF	291.01	291.28	290.96	291.08	2516061.0
2018-09-28 11:30:00	SPY	ETF	291.09	291.17	290.85	290.87	2362336.0
2018-09-28 12:00:00	SPY	ETF	290.8725	291.04	290.8	290.84	1376686.0
2018-09-28 12:30:00	SPY	ETF	290.85	290.95	290.28	290.71	3413226.0
2018-09-28 13:00:00	SPY	ETF	290.7	290.89	290.57	290.87	1334486.0
2018-09-28 13:30:00	SPY	ETF	290.87	291.11	290.84	290.86	2948551.0
2018-09-28 14:00:00	SPY	ETF	290.86	290.87	290.48	290.77	3673953.0
2018-09-28 14:30:00	SPY	ETF	290.76	290.84	290.525	290.57	2578990.0
2018-09-28 15:00:00	SPY	ETF	290.58	290.8	290.44	290.6575	4069496.0
2018-09-28 15:30:00	SPY	ETF	290.655	290.75	290.32	290.61	16750049.0
2018-09-28 16:00:00	SPY	ETF	290.62	290.94	290.5563	290.8	12130143.0
2018-09-28 16:30:00	SPY	ETF	290.79	290.94	290.72	290.89	241758.0
2018-09-28 17:00:00	SPY	ETF	290.84	290.94	290.81	290.94	23278.0
2018-09-28 17:30:00	SPY	ETF	290.9	291.0	290.87	291.0	28782.0
2018-09-28 18:00:00	SPY	ETF	290.95	290.98	290.95	290.98	600.0
2018-09-28 18:30:00	SPY	ETF	290.98	290.99	290.93	290.94	4551.0
2018-09-28 19:00:00	SPY	ETF	290.91	290.94	290.91	290.94	4250.0
2018-09-28 19:30:00	SPY	ETF	290.94	291.0	290.94	291.0	11677.0
2018-09-28 04:00:00	QQQ	ETF	185.77	185.77	185.66	185.66	1397.0
2018-09-28 04:30:00	QQQ	ETF	185.82	185.82	185.77	185.77	1200.0
2018-09-28 05:00:00	QQQ	ETF	185.75	185.75	185.6	185.6	2528.0
2018-09-28 05:30:00	QQQ	ETF	185.55	185.57	185.55	185.57	2520.0
2018-09-28 06:00:00	QQQ	ETF	185.57	185.57	185.25	185.38	12228.0
2018-09-28 06:30:00	QQQ	ETF	185.35	185.41	185.27	185.38	17200.0
2018-09-28 07:00:00	QQQ	ETF	185.33	185.34	185.07	185.15	41922.0
2018-09-28 07:30:00	QQQ	ETF	185.11	185.13	184.79	184.88	92767.0
2018-09-28 08:00:00	QQQ	ETF	185.33	185.83	184.83	185.07	95880.0
2018-09-28 08:30:00	QQQ	ETF	185.06	185.21	185.03	185.19	119619.0
2018-09-28 09:00:00	QQQ	ETF	185.15	185.27	185.08	185.23	146235.0
2018-09-28 09:30:00	QQQ	ETF	185.25	185.68	184.97	185.309	3194590.0
2018-09-28 10:00:00	QQQ	ETF	185.31	185.555	185.05	185.42	2104166.0
2018-09-28 10:30:00	QQQ	ETF	185.42	185.93	185.33	185.81	1456188.0
2018-09-28 11:00:00	QQQ	ETF	185.8107	186.28	185.79	185.98	1345259.0
2018-09-28 11:30:00	QQQ	ETF	186.0	186.06	185.79	185.84	1191874.0
2018-09-28 12:00:00	QQQ	ETF	185.84	186.0	185.71	185.75	574252.0
2018-09-28 12:30:00	QQQ	ETF	185.75	185.8984	185.24	185.61	1362577.0

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

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