PREVIEW / etf_30min / 2018-12-11

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-12-11.parquet
  size:    511 KB
  rows:    17,739

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-12-11 04:00:00	SPY	ETF	263.94	264.19	263.84	264.13	12717.0
2018-12-11 04:30:00	SPY	ETF	264.09	264.5	263.82	264.5	15147.0
2018-12-11 05:00:00	SPY	ETF	264.56	265.5	264.56	265.36	33906.0
2018-12-11 05:30:00	SPY	ETF	265.32	265.77	265.32	265.63	36350.0
2018-12-11 06:00:00	SPY	ETF	265.62	266.12	265.6	265.99	35367.0
2018-12-11 06:30:00	SPY	ETF	266.1	266.78	266.06	266.4	117507.0
2018-12-11 07:00:00	SPY	ETF	266.3	267.22	266.3	267.08	310365.0
2018-12-11 07:30:00	SPY	ETF	267.08	267.21	266.84	266.85	354184.0
2018-12-11 08:00:00	SPY	ETF	266.85	267.2	263.84	267.03	680296.0
2018-12-11 08:30:00	SPY	ETF	267.01	268.1	266.78	267.73	881317.0
2018-12-11 09:00:00	SPY	ETF	267.72	267.72	267.45	267.63	603274.0
2018-12-11 09:30:00	SPY	ETF	267.66	267.87	266.89	267.11	13053528.0
2018-12-11 10:00:00	SPY	ETF	267.11	267.84	266.54	267.56	8025978.0
2018-12-11 10:30:00	SPY	ETF	267.56	267.75	266.0	266.42	6560458.0
2018-12-11 11:00:00	SPY	ETF	266.41	266.5	265.38	265.61	7902688.0
2018-12-11 11:30:00	SPY	ETF	265.62	265.86	264.85	265.6208	8404818.0
2018-12-11 12:00:00	SPY	ETF	265.63	265.63	263.61	264.05	11090995.0
2018-12-11 12:30:00	SPY	ETF	264.08	264.73	263.76	264.205	6090003.0
2018-12-11 13:00:00	SPY	ETF	264.2	264.71	263.77	264.08	4751598.0
2018-12-11 13:30:00	SPY	ETF	264.08	264.27	262.52	262.695	7130541.0
2018-12-11 14:00:00	SPY	ETF	262.71	264.66	262.48	264.54	6671002.0
2018-12-11 14:30:00	SPY	ETF	264.53	265.65	264.5124	264.99	8141508.0
2018-12-11 15:00:00	SPY	ETF	264.99	266.39	264.33	265.43	8494605.0
2018-12-11 15:30:00	SPY	ETF	265.42	266.17	264.0	264.09	14663278.0
2018-12-11 16:00:00	SPY	ETF	264.08	264.54	264.03	264.4	3150048.0
2018-12-11 16:30:00	SPY	ETF	264.41	264.42	263.19	263.47	951838.0
2018-12-11 17:00:00	SPY	ETF	263.46	264.1058	262.73	263.2	396740.0
2018-12-11 17:30:00	SPY	ETF	263.22	263.75	263.22	263.74	156946.0
2018-12-11 18:00:00	SPY	ETF	263.74	264.97	263.59	264.2	433413.0
2018-12-11 18:30:00	SPY	ETF	264.18	264.52	263.75	264.25	60996.0
2018-12-11 19:00:00	SPY	ETF	264.19	264.95	263.77	264.6	129174.0
2018-12-11 19:30:00	SPY	ETF	264.66	265.16	264.66	265.14	116944.0
2018-12-11 04:00:00	QQQ	ETF	162.96	163.07	162.93	163.06	4079.0
2018-12-11 04:30:00	QQQ	ETF	163.06	163.4	162.96	163.4	64043.0
2018-12-11 05:00:00	QQQ	ETF	163.5	164.26	163.5	164.26	16298.0
2018-12-11 05:30:00	QQQ	ETF	164.14	164.44	164.09	164.38	86200.0
2018-12-11 06:00:00	QQQ	ETF	164.37	164.72	164.36	164.72	17949.0
2018-12-11 06:30:00	QQQ	ETF	164.79	165.25	164.77	164.88	72606.0
2018-12-11 07:00:00	QQQ	ETF	164.84	165.44	164.84	165.35	111171.0
2018-12-11 07:30:00	QQQ	ETF	165.28	165.41	165.17	165.23	174505.0
2018-12-11 08:00:00	QQQ	ETF	165.08	165.52	164.9	165.43	139486.0
2018-12-11 08:30:00	QQQ	ETF	165.44	166.05	165.3	165.8	338616.0
2018-12-11 09:00:00	QQQ	ETF	165.782	165.86	165.55	165.62	165460.0
2018-12-11 09:30:00	QQQ	ETF	165.66	165.77	164.9899	165.15	5719981.0
2018-12-11 10:00:00	QQQ	ETF	165.16	165.68	164.47	165.54	4989125.0
2018-12-11 10:30:00	QQQ	ETF	165.54	165.7	164.27	164.57	3374246.0
2018-12-11 11:00:00	QQQ	ETF	164.57	164.77	164.09	164.51	3314793.0
2018-12-11 11:30:00	QQQ	ETF	164.48	164.72	163.91	164.59	2745289.0
2018-12-11 12:00:00	QQQ	ETF	164.59	164.59	163.23	163.67	3291147.0
2018-12-11 12:30:00	QQQ	ETF	163.68	164.1	163.4515	163.76	2283984.0

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

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