PREVIEW / etf_30min / 2018-04-12

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-04-12.parquet
  size:    457 KB
  rows:    15,670

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-04-12 04:00:00	SPY	ETF	264.06	264.21	264.06	264.17	740.0
2018-04-12 04:30:00	SPY	ETF	264.04	264.04	263.73	263.73	923.0
2018-04-12 05:00:00	SPY	ETF	263.58	263.88	263.58	263.88	4002.0
2018-04-12 05:30:00	SPY	ETF	264.04	264.18	264.01	264.18	1650.0
2018-04-12 06:00:00	SPY	ETF	264.2	264.79	264.2	264.76	8540.0
2018-04-12 06:30:00	SPY	ETF	264.84	265.24	264.67	265.12	91750.0
2018-04-12 07:00:00	SPY	ETF	265.17	265.2	264.81	264.91	71792.0
2018-04-12 07:30:00	SPY	ETF	264.9	265.17	264.8	265.01	198128.0
2018-04-12 08:00:00	SPY	ETF	265.13	265.19	263.98	264.98	157784.0
2018-04-12 08:30:00	SPY	ETF	265.02	265.24	264.9	264.95	414987.0
2018-04-12 09:00:00	SPY	ETF	264.96	265.44	264.95	265.26	461165.0
2018-04-12 09:30:00	SPY	ETF	265.26	266.54	265.06	266.49	7353736.0
2018-04-12 10:00:00	SPY	ETF	266.48	266.6699	266.03	266.38	4451386.0
2018-04-12 10:30:00	SPY	ETF	266.38	266.41	265.66	265.83	4942851.0
2018-04-12 11:00:00	SPY	ETF	265.83	266.53	265.77	266.25	2765000.0
2018-04-12 11:30:00	SPY	ETF	266.25	266.46	265.57	266.02	2819930.0
2018-04-12 12:00:00	SPY	ETF	266.02	266.33	265.84	266.31	1806024.0
2018-04-12 12:30:00	SPY	ETF	266.31	266.8	266.21	266.645	3381668.0
2018-04-12 13:00:00	SPY	ETF	266.65	266.72	265.19	265.28	5851458.0
2018-04-12 13:30:00	SPY	ETF	265.27	266.1	265.1	265.615	4298956.0
2018-04-12 14:00:00	SPY	ETF	265.61	266.545	265.51	266.39	3924157.0
2018-04-12 14:30:00	SPY	ETF	266.39	266.54	265.9	266.475	2719992.0
2018-04-12 15:00:00	SPY	ETF	266.48	267.0	266.13	266.91	5162394.0
2018-04-12 15:30:00	SPY	ETF	266.9	266.97	265.88	265.91	12482597.0
2018-04-12 16:00:00	SPY	ETF	265.9	266.1	265.73	265.87	2916350.0
2018-04-12 16:30:00	SPY	ETF	265.86	266.07	265.79	266.03	290046.0
2018-04-12 17:00:00	SPY	ETF	266.04	266.04	265.85	265.98	267327.0
2018-04-12 17:30:00	SPY	ETF	265.96	266.03	265.91	265.95	36804.0
2018-04-12 18:00:00	SPY	ETF	265.9	265.9	265.1	265.5	199292.0
2018-04-12 18:30:00	SPY	ETF	265.52	265.56	264.81	265.0	100789.0
2018-04-12 19:00:00	SPY	ETF	265.0	265.2	264.91	265.14	69726.0
2018-04-12 19:30:00	SPY	ETF	265.14	265.23	264.91	265.2	75042.0
2018-04-12 20:00:00	SPY	ETF	265.93	265.93	265.25	265.25	480.0
2018-04-12 04:00:00	QQQ	ETF	160.71	160.81	160.68	160.78	2100.0
2018-04-12 04:30:00	QQQ	ETF	160.72	160.72	160.35	160.35	6681.0
2018-04-12 05:00:00	QQQ	ETF	160.28	160.49	160.28	160.49	19200.0
2018-04-12 05:30:00	QQQ	ETF	160.58	160.68	160.55	160.68	3460.0
2018-04-12 06:00:00	QQQ	ETF	160.79	161.01	160.78	161.01	5180.0
2018-04-12 06:30:00	QQQ	ETF	161.08	161.45	161.04	161.28	18785.0
2018-04-12 07:00:00	QQQ	ETF	161.28	161.33	161.16	161.24	53163.0
2018-04-12 07:30:00	QQQ	ETF	161.25	161.42	161.13	161.28	67521.0
2018-04-12 08:00:00	QQQ	ETF	161.28	161.36	161.15	161.17	68690.0
2018-04-12 08:30:00	QQQ	ETF	161.2	161.4	161.16	161.19	81427.0
2018-04-12 09:00:00	QQQ	ETF	161.24	161.52	161.23	161.31	275653.0
2018-04-12 09:30:00	QQQ	ETF	161.3	162.31	161.16	162.31	4533285.0
2018-04-12 10:00:00	QQQ	ETF	162.305	162.7052	162.14	162.49	2671232.0
2018-04-12 10:30:00	QQQ	ETF	162.49	162.52	162.01	162.16	1845253.0
2018-04-12 11:00:00	QQQ	ETF	162.14	162.5562	162.04	162.37	1012664.0
2018-04-12 11:30:00	QQQ	ETF	162.38	162.52	161.81	162.14	1187148.0
2018-04-12 12:00:00	QQQ	ETF	162.14	162.34	161.93	162.29	779644.0

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

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