PREVIEW / etf_30min / 2019-01-22

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-01-22.parquet
  size:    519 KB
  rows:    18,208

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
2019-01-22 04:00:00	SPY	ETF	265.11	265.25	264.91	264.97	23798.0
2019-01-22 04:30:00	SPY	ETF	265.09	265.2	264.9	264.98	16505.0
2019-01-22 05:00:00	SPY	ETF	265.0	265.02	264.8	264.85	4995.0
2019-01-22 05:30:00	SPY	ETF	264.82	264.83	264.65	264.65	30737.0
2019-01-22 06:00:00	SPY	ETF	264.65	264.67	264.31	264.45	28711.0
2019-01-22 06:30:00	SPY	ETF	264.35	264.65	264.3	264.62	58667.0
2019-01-22 07:00:00	SPY	ETF	264.67	265.0	264.63	264.98	143386.0
2019-01-22 07:30:00	SPY	ETF	264.99	265.11	264.88	264.9	152236.0
2019-01-22 08:00:00	SPY	ETF	265.0503	266.151	264.4	264.92	169262.0
2019-01-22 08:30:00	SPY	ETF	264.92	264.95	264.65	264.8	160695.0
2019-01-22 09:00:00	SPY	ETF	264.78	266.46	264.66	264.83	549128.0
2019-01-22 09:30:00	SPY	ETF	264.82	265.06	264.02	264.3962	8648082.0
2019-01-22 10:00:00	SPY	ETF	264.4	264.4	263.54	264.09	6737462.0
2019-01-22 10:30:00	SPY	ETF	264.1	264.4	263.75	263.79	4218630.0
2019-01-22 11:00:00	SPY	ETF	263.77	264.18	263.6	263.94	3795294.0
2019-01-22 11:30:00	SPY	ETF	263.93	264.16	262.83	262.88	5223904.0
2019-01-22 12:00:00	SPY	ETF	262.88	263.28	262.6601	262.88	4770299.0
2019-01-22 12:30:00	SPY	ETF	262.88	263.21	262.75	262.95	2315181.0
2019-01-22 13:00:00	SPY	ETF	262.94	262.94	261.725	262.2	8832302.0
2019-01-22 13:30:00	SPY	ETF	262.21	262.65	262.09	262.51	4768084.0
2019-01-22 14:00:00	SPY	ETF	262.5	262.56	261.835	261.85	4126855.0
2019-01-22 14:30:00	SPY	ETF	261.855	262.04	261.21	261.7	5973729.0
2019-01-22 15:00:00	SPY	ETF	261.69	262.08	261.06	261.975	7740545.0
2019-01-22 15:30:00	SPY	ETF	261.98	262.93	261.2	262.93	25986401.0
2019-01-22 16:00:00	SPY	ETF	262.925	263.2	262.49	262.67	18332599.0
2019-01-22 16:30:00	SPY	ETF	262.67	262.86	262.47	262.67	351496.0
2019-01-22 17:00:00	SPY	ETF	262.74	262.97	262.68	262.97	226454.0
2019-01-22 17:30:00	SPY	ETF	262.97	263.0	262.7	262.73	139723.0
2019-01-22 18:00:00	SPY	ETF	262.71	262.73	262.24	262.32	95049.0
2019-01-22 18:30:00	SPY	ETF	262.32	262.69	262.24	262.47	44989.0
2019-01-22 19:00:00	SPY	ETF	262.51	262.79	262.41	262.73	38375.0
2019-01-22 19:30:00	SPY	ETF	262.77	262.85	262.59	262.67	28945.0
2019-01-22 04:00:00	QQQ	ETF	164.06	164.08	163.83	164.0	30945.0
2019-01-22 04:30:00	QQQ	ETF	164.06	164.07	163.88	163.92	9700.0
2019-01-22 05:00:00	QQQ	ETF	163.91	163.95	163.76	163.81	11675.0
2019-01-22 05:30:00	QQQ	ETF	163.76	163.78	163.71	163.72	35373.0
2019-01-22 06:00:00	QQQ	ETF	163.67	163.68	163.47	163.57	27413.0
2019-01-22 06:30:00	QQQ	ETF	163.51	163.74	163.46	163.74	12318.0
2019-01-22 07:00:00	QQQ	ETF	163.76	163.92	163.73	163.92	64389.0
2019-01-22 07:30:00	QQQ	ETF	163.91	164.02	163.88	163.92	53242.0
2019-01-22 08:00:00	QQQ	ETF	165.25	165.25	163.5	163.97	180629.0
2019-01-22 08:30:00	QQQ	ETF	163.98	164.04	163.88	163.95	137156.0
2019-01-22 09:00:00	QQQ	ETF	163.98	165.25	163.85	164.02	514881.0
2019-01-22 09:30:00	QQQ	ETF	164.05	164.14	163.3	163.69	4711640.0
2019-01-22 10:00:00	QQQ	ETF	163.69	163.69	163.1	163.35	3128662.0
2019-01-22 10:30:00	QQQ	ETF	163.37	163.6468	163.18	163.27	1871481.0
2019-01-22 11:00:00	QQQ	ETF	163.26	163.48	163.0199	163.2799	1767176.0
2019-01-22 11:30:00	QQQ	ETF	163.275	163.44	162.4801	162.52	2407986.0
2019-01-22 12:00:00	QQQ	ETF	162.51	162.83	162.33	162.52	2500864.0
2019-01-22 12:30:00	QQQ	ETF	162.51	162.735	162.41	162.48	925230.0

> showing 50 of 18,208 rows — these rows as CSV

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