PREVIEW / etf_30min / 2018-05-14

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-05-14.parquet
  size:    460 KB
  rows:    16,058

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-14 04:00:00	SPY	ETF	273.28	273.56	273.28	273.56	12522.0
2018-05-14 04:30:00	SPY	ETF	273.51	273.53	273.4	273.42	4988.0
2018-05-14 05:00:00	SPY	ETF	273.48	273.55	273.45	273.55	3650.0
2018-05-14 05:30:00	SPY	ETF	273.55	273.6	273.51	273.51	11040.0
2018-05-14 06:00:00	SPY	ETF	273.47	273.49	273.37	273.37	6681.0
2018-05-14 06:30:00	SPY	ETF	273.37	273.43	273.3	273.43	13325.0
2018-05-14 07:00:00	SPY	ETF	273.42	273.47	273.33	273.39	56716.0
2018-05-14 07:30:00	SPY	ETF	273.36	273.41	273.26	273.26	79787.0
2018-05-14 08:00:00	SPY	ETF	273.43	274.07	273.22	273.28	70083.0
2018-05-14 08:30:00	SPY	ETF	273.3	273.32	273.2	273.28	205579.0
2018-05-14 09:00:00	SPY	ETF	273.29	273.43	273.24	273.35	301513.0
2018-05-14 09:30:00	SPY	ETF	273.34	273.92	273.3008	273.76	5089203.0
2018-05-14 10:00:00	SPY	ETF	273.7575	273.92	273.44	273.91	2516920.0
2018-05-14 10:30:00	SPY	ETF	273.92	274.08	273.56	273.56	3199892.0
2018-05-14 11:00:00	SPY	ETF	273.56	273.91	273.45	273.49	2946068.0
2018-05-14 11:30:00	SPY	ETF	273.5	273.64	273.21	273.45	1654943.0
2018-05-14 12:00:00	SPY	ETF	273.455	273.81	273.33	273.37	2174980.0
2018-05-14 12:30:00	SPY	ETF	273.36	273.49	272.94	272.97	1889653.0
2018-05-14 13:00:00	SPY	ETF	272.96	273.06	272.57	272.825	2653194.0
2018-05-14 13:30:00	SPY	ETF	272.825	273.13	272.56	272.9	2028485.0
2018-05-14 14:00:00	SPY	ETF	272.9	272.95	272.36	272.76	2965209.0
2018-05-14 14:30:00	SPY	ETF	272.77	273.055	272.64	272.995	2869296.0
2018-05-14 15:00:00	SPY	ETF	272.99	273.215	272.855	273.03	3077498.0
2018-05-14 15:30:00	SPY	ETF	273.03	273.11	272.47	272.92	11902029.0
2018-05-14 16:00:00	SPY	ETF	272.91	273.1124	272.41	272.96	5992411.0
2018-05-14 16:30:00	SPY	ETF	272.96	272.98	272.71	272.83	160411.0
2018-05-14 17:00:00	SPY	ETF	272.84	272.85	272.74	272.74	20147.0
2018-05-14 17:30:00	SPY	ETF	272.74	272.83	272.74	272.76	9845.0
2018-05-14 18:00:00	SPY	ETF	272.77	273.0	272.77	272.98	51909.0
2018-05-14 18:30:00	SPY	ETF	272.91	272.97	272.85	272.96	10322.0
2018-05-14 19:00:00	SPY	ETF	272.97	272.98	272.8	272.86	8877.0
2018-05-14 19:30:00	SPY	ETF	272.89	272.97	272.88	272.95	8180.0
2018-05-14 20:00:00	SPY	ETF	272.98	272.98	272.8542	272.8542	14700.0
2018-05-14 04:00:00	QQQ	ETF	169.91	170.01	169.87	170.01	4758.0
2018-05-14 04:30:00	QQQ	ETF	169.97	170.0	169.95	169.98	3280.0
2018-05-14 05:00:00	QQQ	ETF	169.96	170.01	169.96	170.01	1000.0
2018-05-14 05:30:00	QQQ	ETF	170.1	170.11	169.99	170.03	13870.0
2018-05-14 06:00:00	QQQ	ETF	170.02	170.05	169.95	169.95	9100.0
2018-05-14 06:30:00	QQQ	ETF	169.94	169.97	169.91	169.97	4074.0
2018-05-14 07:00:00	QQQ	ETF	169.95	169.95	169.86	169.86	18905.0
2018-05-14 07:30:00	QQQ	ETF	169.85	169.9	169.77	169.81	18880.0
2018-05-14 08:00:00	QQQ	ETF	169.9599	170.12	169.8	169.82	270178.0
2018-05-14 08:30:00	QQQ	ETF	169.84	169.85	169.74	169.8	112520.0
2018-05-14 09:00:00	QQQ	ETF	169.8	169.91	169.79	169.85	143308.0
2018-05-14 09:30:00	QQQ	ETF	169.85	170.46	169.8398	170.24	2723093.0
2018-05-14 10:00:00	QQQ	ETF	170.24	170.66	170.1342	170.65	1133394.0
2018-05-14 10:30:00	QQQ	ETF	170.65	170.82	170.47	170.48	1203206.0
2018-05-14 11:00:00	QQQ	ETF	170.46	170.74	170.33	170.37	824934.0
2018-05-14 11:30:00	QQQ	ETF	170.37	170.479	170.1208	170.275	778487.0
2018-05-14 12:00:00	QQQ	ETF	170.27	170.46	170.11	170.39	1021885.0

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

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