PREVIEW / etf_30min / 2018-11-26

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-11-26.parquet
  size:    488 KB
  rows:    16,920

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-11-26 04:00:00	SPY	ETF	266.35	266.62	266.21	266.42	41522.0
2018-11-26 04:30:00	SPY	ETF	266.47	266.65	266.4	266.4	8075.0
2018-11-26 05:00:00	SPY	ETF	266.38	266.46	266.1	266.1	24483.0
2018-11-26 05:30:00	SPY	ETF	266.03	266.2	266.02	266.19	27575.0
2018-11-26 06:00:00	SPY	ETF	266.19	266.37	265.98	266.12	31879.0
2018-11-26 06:30:00	SPY	ETF	266.11	266.2	266.01	266.06	37109.0
2018-11-26 07:00:00	SPY	ETF	266.06	266.37	265.85	266.0	223238.0
2018-11-26 07:30:00	SPY	ETF	266.0	266.16	265.85	265.85	510512.0
2018-11-26 08:00:00	SPY	ETF	265.85	266.27	264.76	265.83	221045.0
2018-11-26 08:30:00	SPY	ETF	265.86	265.94	265.57	265.92	292783.0
2018-11-26 09:00:00	SPY	ETF	265.92	266.02	265.74	265.79	349963.0
2018-11-26 09:30:00	SPY	ETF	265.78	267.17	265.64	267.16	9488253.0
2018-11-26 10:00:00	SPY	ETF	267.18	267.245	266.48	266.72	4831594.0
2018-11-26 10:30:00	SPY	ETF	266.73	267.15	266.31	267.0525	7175426.0
2018-11-26 11:00:00	SPY	ETF	267.06	267.1	266.57	266.6799	4947636.0
2018-11-26 11:30:00	SPY	ETF	266.66	266.665	265.92	266.4	5074132.0
2018-11-26 12:00:00	SPY	ETF	266.4	266.8	265.91	266.04	3697316.0
2018-11-26 12:30:00	SPY	ETF	266.03	266.03	265.34	265.84	4383009.0
2018-11-26 13:00:00	SPY	ETF	265.82	266.27	265.54	266.06	2490463.0
2018-11-26 13:30:00	SPY	ETF	266.07	266.71	265.9	266.65	2412959.0
2018-11-26 14:00:00	SPY	ETF	266.64	267.11	266.49	266.993	2823582.0
2018-11-26 14:30:00	SPY	ETF	266.99	267.47	266.79	267.37	3330995.0
2018-11-26 15:00:00	SPY	ETF	267.3685	267.75	266.91	267.0213	3808527.0
2018-11-26 15:30:00	SPY	ETF	267.03	267.55	267.02	267.46	11397930.0
2018-11-26 16:00:00	SPY	ETF	267.44	267.7	266.31	266.78	8636219.0
2018-11-26 16:30:00	SPY	ETF	266.72	267.5	266.16	266.2	2079727.0
2018-11-26 17:00:00	SPY	ETF	266.2	266.54	266.2	266.46	116518.0
2018-11-26 17:30:00	SPY	ETF	266.48	267.5	266.26	266.26	52448.0
2018-11-26 18:00:00	SPY	ETF	266.25	266.49	266.0	266.08	145230.0
2018-11-26 18:30:00	SPY	ETF	266.12	266.33	266.12	266.22	31565.0
2018-11-26 19:00:00	SPY	ETF	266.21	266.22	265.96	266.22	14999.0
2018-11-26 19:30:00	SPY	ETF	266.18	266.2	265.73	265.78	38878.0
2018-11-26 04:00:00	QQQ	ETF	161.63	162.12	161.63	162.12	81939.0
2018-11-26 04:30:00	QQQ	ETF	162.1	162.16	161.89	162.05	6776.0
2018-11-26 05:00:00	QQQ	ETF	161.88	161.88	161.79	161.79	1410.0
2018-11-26 05:30:00	QQQ	ETF	161.71	161.97	161.71	161.88	4861.0
2018-11-26 06:00:00	QQQ	ETF	161.88	161.97	161.6	161.87	34026.0
2018-11-26 06:30:00	QQQ	ETF	161.9	161.9	161.7	161.82	39181.0
2018-11-26 07:00:00	QQQ	ETF	161.76	161.9	161.51	161.68	101961.0
2018-11-26 07:30:00	QQQ	ETF	161.65	161.76	161.61	161.68	44915.0
2018-11-26 08:00:00	QQQ	ETF	161.7799	161.89	160.5	161.58	127717.0
2018-11-26 08:30:00	QQQ	ETF	161.6	161.64	161.35	161.54	128418.0
2018-11-26 09:00:00	QQQ	ETF	161.53	161.62	161.38	161.42	182855.0
2018-11-26 09:30:00	QQQ	ETF	161.43	162.29	160.8	162.2899	5141467.0
2018-11-26 10:00:00	QQQ	ETF	162.28	162.43	161.56	161.77	2735358.0
2018-11-26 10:30:00	QQQ	ETF	161.77	162.25	161.47	162.15	2773308.0
2018-11-26 11:00:00	QQQ	ETF	162.16	162.29	161.66	161.99	2073286.0
2018-11-26 11:30:00	QQQ	ETF	161.97	161.97	161.2901	161.66	1588686.0
2018-11-26 12:00:00	QQQ	ETF	161.67	162.03	161.19	161.3	1522884.0
2018-11-26 12:30:00	QQQ	ETF	161.28	161.3501	160.76	161.34	1687781.0

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

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