PREVIEW / etf_30min / 2018-01-24

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-01-24.parquet
  size:    500 KB
  rows:    17,273

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-01-24 04:00:00	SPY	ETF	283.53	283.62	283.43	283.62	3120.0
2018-01-24 04:30:00	SPY	ETF	283.57	283.57	283.52	283.53	1600.0
2018-01-24 05:00:00	SPY	ETF	283.58	283.65	283.58	283.65	2500.0
2018-01-24 05:30:00	SPY	ETF	283.67	283.79	283.66	283.66	9800.0
2018-01-24 06:00:00	SPY	ETF	283.64	283.64	283.56	283.63	9200.0
2018-01-24 06:30:00	SPY	ETF	283.63	283.63	283.48	283.53	25993.0
2018-01-24 07:00:00	SPY	ETF	283.54	283.77	283.52	283.74	75061.0
2018-01-24 07:30:00	SPY	ETF	283.77	283.92	283.64	283.67	119765.0
2018-01-24 08:00:00	SPY	ETF	283.72	283.91	283.45	283.88	282624.0
2018-01-24 08:30:00	SPY	ETF	283.87	284.18	283.87	284.0	445927.0
2018-01-24 09:00:00	SPY	ETF	283.99	284.08	283.85	283.99	385071.0
2018-01-24 09:30:00	SPY	ETF	284.02	284.34	283.75	284.28	8685287.0
2018-01-24 10:00:00	SPY	ETF	284.28	284.645	284.21	284.3651	6878402.0
2018-01-24 10:30:00	SPY	ETF	284.365	284.7	284.07	284.19	7319466.0
2018-01-24 11:00:00	SPY	ETF	284.18	284.35	283.22	283.39	10050898.0
2018-01-24 11:30:00	SPY	ETF	283.38	283.43	282.38	283.19	8939169.0
2018-01-24 12:00:00	SPY	ETF	283.18	283.36	282.58	282.82	4247114.0
2018-01-24 12:30:00	SPY	ETF	282.82	282.88	282.26	282.68	4353762.0
2018-01-24 13:00:00	SPY	ETF	282.68	282.73	281.84	282.5156	10471047.0
2018-01-24 13:30:00	SPY	ETF	282.515	283.42	282.51	283.14	9768385.0
2018-01-24 14:00:00	SPY	ETF	283.14	283.53	282.99	283.52	11616506.0
2018-01-24 14:30:00	SPY	ETF	283.52	283.76	283.26	283.46	5703639.0
2018-01-24 15:00:00	SPY	ETF	283.48	283.5	283.105	283.29	5457253.0
2018-01-24 15:30:00	SPY	ETF	283.29	283.77	283.06	283.18	14224471.0
2018-01-24 16:00:00	SPY	ETF	283.17	283.42	283.05	283.32	18635400.0
2018-01-24 16:30:00	SPY	ETF	283.31	284.05	283.092	283.34	2993610.0
2018-01-24 17:00:00	SPY	ETF	283.26	283.35	283.21	283.21	95041.0
2018-01-24 17:30:00	SPY	ETF	283.23	283.3	283.22	283.25	2426007.0
2018-01-24 18:00:00	SPY	ETF	283.26	283.26	282.76	282.76	190894.0
2018-01-24 18:30:00	SPY	ETF	282.79	282.95	282.78	282.95	26805.0
2018-01-24 19:00:00	SPY	ETF	282.95	283.11	282.81	283.04	28251.0
2018-01-24 19:30:00	SPY	ETF	283.0	283.29	283.0	283.24	21964.0
2018-01-24 04:00:00	QQQ	ETF	169.51	169.58	169.48	169.56	8500.0
2018-01-24 04:30:00	QQQ	ETF	169.55	169.57	169.51	169.51	10333.0
2018-01-24 05:00:00	QQQ	ETF	169.53	169.58	169.52	169.58	11521.0
2018-01-24 05:30:00	QQQ	ETF	169.58	169.8	169.57	169.71	23921.0
2018-01-24 06:00:00	QQQ	ETF	169.5	169.67	169.5	169.63	4600.0
2018-01-24 06:30:00	QQQ	ETF	169.51	169.57	169.4	169.45	92337.0
2018-01-24 07:00:00	QQQ	ETF	169.48	169.51	169.43	169.48	90740.0
2018-01-24 07:30:00	QQQ	ETF	169.47	169.58	169.43	169.43	55678.0
2018-01-24 08:00:00	QQQ	ETF	169.47	169.71	169.43	169.71	91218.0
2018-01-24 08:30:00	QQQ	ETF	169.72	169.98	169.71	169.85	85954.0
2018-01-24 09:00:00	QQQ	ETF	169.83	169.89	169.71	169.8	179593.0
2018-01-24 09:30:00	QQQ	ETF	169.81	169.9699	169.29	169.7189	4591443.0
2018-01-24 10:00:00	QQQ	ETF	169.72	170.13	169.69	170.02	3779237.0
2018-01-24 10:30:00	QQQ	ETF	170.03	170.24	169.6	169.73	2455063.0
2018-01-24 11:00:00	QQQ	ETF	169.73	169.82	168.77	168.911	4190173.0
2018-01-24 11:30:00	QQQ	ETF	168.91	168.91	168.08	168.67	4947701.0
2018-01-24 12:00:00	QQQ	ETF	168.67	168.81	168.26	168.4256	2213412.0
2018-01-24 12:30:00	QQQ	ETF	168.43	168.499	167.91	168.28	2594275.0

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

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