PREVIEW / etf_30min / 2019-01-29

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-01-29.parquet
  size:    491 KB
  rows:    16,941

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-29 04:00:00	SPY	ETF	263.37	263.68	263.32	263.53	5579.0
2019-01-29 04:30:00	SPY	ETF	263.57	263.57	263.35	263.57	2110.0
2019-01-29 05:00:00	SPY	ETF	263.57	263.77	263.45	263.73	8303.0
2019-01-29 05:30:00	SPY	ETF	263.78	263.82	263.58	263.58	9626.0
2019-01-29 06:00:00	SPY	ETF	263.62	263.62	263.37	263.37	2860.0
2019-01-29 06:30:00	SPY	ETF	263.42	263.83	263.42	263.81	15390.0
2019-01-29 07:00:00	SPY	ETF	263.81	263.87	263.65	263.67	77713.0
2019-01-29 07:30:00	SPY	ETF	263.66	264.15	263.65	264.02	109673.0
2019-01-29 08:00:00	SPY	ETF	263.76	264.24	262.85	264.09	141740.0
2019-01-29 08:30:00	SPY	ETF	264.1	264.28	264.1	264.2	128745.0
2019-01-29 09:00:00	SPY	ETF	264.2	264.28	263.87	263.92	261649.0
2019-01-29 09:30:00	SPY	ETF	263.92	264.49	263.56	264.2	5403995.0
2019-01-29 10:00:00	SPY	ETF	264.2	264.55	263.38	264.17	5248892.0
2019-01-29 10:30:00	SPY	ETF	264.17	264.27	262.48	262.73	6155916.0
2019-01-29 11:00:00	SPY	ETF	262.73	263.18	262.53	263.06	5787181.0
2019-01-29 11:30:00	SPY	ETF	263.05	263.49	263.04	263.4	3067779.0
2019-01-29 12:00:00	SPY	ETF	263.39	263.98	263.2385	263.66	3096124.0
2019-01-29 12:30:00	SPY	ETF	263.67	263.79	263.36	263.5	2451194.0
2019-01-29 13:00:00	SPY	ETF	263.49	263.68	263.3	263.63	1768046.0
2019-01-29 13:30:00	SPY	ETF	263.64	263.99	263.475	263.8655	2289644.0
2019-01-29 14:00:00	SPY	ETF	263.8699	263.8699	263.31	263.39	1904299.0
2019-01-29 14:30:00	SPY	ETF	263.39	263.54	262.965	263.0	3558183.0
2019-01-29 15:00:00	SPY	ETF	263.0	263.46	262.9	263.4	3239923.0
2019-01-29 15:30:00	SPY	ETF	263.41	263.59	263.09	263.43	11407236.0
2019-01-29 16:00:00	SPY	ETF	263.44	263.9	263.2	263.82	6485876.0
2019-01-29 16:30:00	SPY	ETF	263.82	264.4	263.41	264.35	626941.0
2019-01-29 17:00:00	SPY	ETF	264.22	264.69	264.2	264.6899	353890.0
2019-01-29 17:30:00	SPY	ETF	264.68	264.69	264.37	264.42	185003.0
2019-01-29 18:00:00	SPY	ETF	264.5	264.6	263.58	264.3	727517.0
2019-01-29 18:30:00	SPY	ETF	264.31	264.31	264.05	264.05	61207.0
2019-01-29 19:00:00	SPY	ETF	264.05	264.11	263.74	263.77	126622.0
2019-01-29 19:30:00	SPY	ETF	263.84	263.96	263.79	263.95	53592.0
2019-01-29 04:00:00	QQQ	ETF	162.52	162.76	162.52	162.71	13397.0
2019-01-29 04:30:00	QQQ	ETF	162.7	162.71	162.59	162.7	4000.0
2019-01-29 05:00:00	QQQ	ETF	162.7	162.94	162.66	162.82	68740.0
2019-01-29 05:30:00	QQQ	ETF	162.9	162.94	162.74	162.74	26472.0
2019-01-29 06:00:00	QQQ	ETF	162.74	162.81	162.57	162.57	10400.0
2019-01-29 06:30:00	QQQ	ETF	162.63	163.0	162.62	163.0	67774.0
2019-01-29 07:00:00	QQQ	ETF	162.98	163.03	162.91	162.95	24262.0
2019-01-29 07:30:00	QQQ	ETF	162.99	163.35	162.95	163.31	108531.0
2019-01-29 08:00:00	QQQ	ETF	163.17	163.51	162.24	163.42	101681.0
2019-01-29 08:30:00	QQQ	ETF	163.48	163.51	163.41	163.44	47115.0
2019-01-29 09:00:00	QQQ	ETF	163.44	163.49	163.15	163.15	104985.0
2019-01-29 09:30:00	QQQ	ETF	163.2	163.24	162.45	162.72	2208191.0
2019-01-29 10:00:00	QQQ	ETF	162.71	163.11	162.25	162.63	2089044.0
2019-01-29 10:30:00	QQQ	ETF	162.66	162.73	160.99	161.21	2914482.0
2019-01-29 11:00:00	QQQ	ETF	161.22	161.57	161.05	161.4166	2225863.0
2019-01-29 11:30:00	QQQ	ETF	161.4199	161.7	161.39	161.5386	1085782.0
2019-01-29 12:00:00	QQQ	ETF	161.54	162.07	161.4154	161.89	1499286.0
2019-01-29 12:30:00	QQQ	ETF	161.89	162.02	161.71	161.84	676963.0

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

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