PREVIEW / etf_30min / 2018-10-12

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-10-12.parquet
  size:    517 KB
  rows:    17,941

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-10-12 04:00:00	SPY	ETF	276.5	277.0	276.08	276.33	61677.0
2018-10-12 04:30:00	SPY	ETF	276.13	276.2	275.74	275.76	61095.0
2018-10-12 05:00:00	SPY	ETF	275.77	275.97	275.42	275.97	53934.0
2018-10-12 05:30:00	SPY	ETF	275.89	276.21	275.88	276.0	50894.0
2018-10-12 06:00:00	SPY	ETF	275.94	276.18	275.56	275.94	67914.0
2018-10-12 06:30:00	SPY	ETF	275.98	276.55	275.88	276.45	153684.0
2018-10-12 07:00:00	SPY	ETF	276.49	276.81	276.25	276.59	350337.0
2018-10-12 07:30:00	SPY	ETF	276.56	276.63	276.07	276.24	289461.0
2018-10-12 08:00:00	SPY	ETF	276.4	277.32	272.17	276.75	484966.0
2018-10-12 08:30:00	SPY	ETF	276.75	276.9	276.12	276.37	537034.0
2018-10-12 09:00:00	SPY	ETF	276.37	277.05	276.3	276.82	1815793.0
2018-10-12 09:30:00	SPY	ETF	276.77	277.09	275.67	276.6331	18097254.0
2018-10-12 10:00:00	SPY	ETF	276.62	276.95	275.08	275.1	12928293.0
2018-10-12 10:30:00	SPY	ETF	275.09	276.65	275.07	276.1111	9397736.0
2018-10-12 11:00:00	SPY	ETF	276.12	276.5	275.38	275.63	7702689.0
2018-10-12 11:30:00	SPY	ETF	275.62	275.87	274.22	274.87	10457376.0
2018-10-12 12:00:00	SPY	ETF	274.87	274.91	273.55	273.93	9312470.0
2018-10-12 12:30:00	SPY	ETF	273.9015	274.21	272.37	273.57	14423585.0
2018-10-12 13:00:00	SPY	ETF	273.56	274.74	273.15	273.82	10218582.0
2018-10-12 13:30:00	SPY	ETF	273.83	274.44	272.88	273.85	9415700.0
2018-10-12 14:00:00	SPY	ETF	273.849	274.03	272.66	274.0	8685766.0
2018-10-12 14:30:00	SPY	ETF	273.99	274.63	273.01	274.45	9843142.0
2018-10-12 15:00:00	SPY	ETF	274.45	275.92	273.9	275.77	13723827.0
2018-10-12 15:30:00	SPY	ETF	275.76	277.015	275.26	276.01	25300124.0
2018-10-12 16:00:00	SPY	ETF	276.015	276.5	275.62	276.01	16444708.0
2018-10-12 16:30:00	SPY	ETF	276.0	276.4	275.93	276.35	364788.0
2018-10-12 17:00:00	SPY	ETF	276.36	276.36	275.94	276.01	795003.0
2018-10-12 17:30:00	SPY	ETF	276.01	276.15	275.95	276.13	92210.0
2018-10-12 18:00:00	SPY	ETF	276.11	276.28	276.08	276.1	31924.0
2018-10-12 18:30:00	SPY	ETF	276.1	276.34	276.08	276.34	33259.0
2018-10-12 19:00:00	SPY	ETF	276.33	276.47	275.95	276.47	57966.0
2018-10-12 19:30:00	SPY	ETF	276.49	277.16	276.47	277.12	132102.0
2018-10-12 04:00:00	QQQ	ETF	173.59	173.9	172.98	173.13	127399.0
2018-10-12 04:30:00	QQQ	ETF	173.09	173.14	172.8	172.8	25600.0
2018-10-12 05:00:00	QQQ	ETF	172.81	173.12	172.64	173.12	32285.0
2018-10-12 05:30:00	QQQ	ETF	173.1	173.56	173.08	173.3	47514.0
2018-10-12 06:00:00	QQQ	ETF	173.23	173.44	172.85	173.11	60404.0
2018-10-12 06:30:00	QQQ	ETF	173.21	173.65	173.06	173.5	53285.0
2018-10-12 07:00:00	QQQ	ETF	173.52	173.66	173.37	173.46	217879.0
2018-10-12 07:30:00	QQQ	ETF	173.44	173.49	173.08	173.25	343963.0
2018-10-12 08:00:00	QQQ	ETF	173.5	173.93	172.35	173.53	341913.0
2018-10-12 08:30:00	QQQ	ETF	173.55	173.74	173.05	173.29	586540.0
2018-10-12 09:00:00	QQQ	ETF	173.25	174.1	173.24	173.99	2042426.0
2018-10-12 09:30:00	QQQ	ETF	173.99	174.28	172.94	173.72	14507260.0
2018-10-12 10:00:00	QQQ	ETF	173.7	174.33	173.0	173.01	8376358.0
2018-10-12 10:30:00	QQQ	ETF	173.01	174.19	172.99	173.55	5456779.0
2018-10-12 11:00:00	QQQ	ETF	173.555	173.91	173.16	173.38	3379130.0
2018-10-12 11:30:00	QQQ	ETF	173.37	173.67	172.15	172.6064	5563338.0
2018-10-12 12:00:00	QQQ	ETF	172.61	172.66	171.8	172.13	5300257.0
2018-10-12 12:30:00	QQQ	ETF	172.1393	172.3	170.9328	172.13	6462803.0

> showing 50 of 17,941 rows — these rows as CSV

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