PREVIEW / etf_30min / 2019-02-13

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-02-13.parquet
  size:    496 KB
  rows:    17,277

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-02-13 04:00:00	SPY	ETF	274.82	274.88	274.69	274.69	2536.0
2019-02-13 04:30:00	SPY	ETF	274.69	274.69	274.49	274.49	2300.0
2019-02-13 05:00:00	SPY	ETF	274.44	274.66	274.44	274.45	21789.0
2019-02-13 05:30:00	SPY	ETF	274.51	274.65	274.51	274.65	14100.0
2019-02-13 06:00:00	SPY	ETF	274.69	274.78	274.53	274.78	20398.0
2019-02-13 06:30:00	SPY	ETF	274.78	274.93	274.71	274.93	17145.0
2019-02-13 07:00:00	SPY	ETF	274.91	275.0	274.88	274.94	54626.0
2019-02-13 07:30:00	SPY	ETF	274.93	275.04	274.88	274.89	43337.0
2019-02-13 08:00:00	SPY	ETF	274.91	275.35	274.82	274.85	58169.0
2019-02-13 08:30:00	SPY	ETF	274.84	275.18	274.5	275.14	214352.0
2019-02-13 09:00:00	SPY	ETF	275.14	275.2	274.87	275.04	507539.0
2019-02-13 09:30:00	SPY	ETF	275.03	275.93	274.95	275.53	8833250.0
2019-02-13 10:00:00	SPY	ETF	275.52	275.74	275.1	275.5401	4426240.0
2019-02-13 10:30:00	SPY	ETF	275.54	275.84	275.3399	275.59	4090810.0
2019-02-13 11:00:00	SPY	ETF	275.59	275.84	274.97	275.0017	3687013.0
2019-02-13 11:30:00	SPY	ETF	275.0	275.05	274.56	275.01	4603413.0
2019-02-13 12:00:00	SPY	ETF	275.02	275.08	274.61	274.77	2285236.0
2019-02-13 12:30:00	SPY	ETF	274.77	274.95	274.63	274.83	1825561.0
2019-02-13 13:00:00	SPY	ETF	274.84	275.1	274.77	275.06	1640921.0
2019-02-13 13:30:00	SPY	ETF	275.06	275.08	274.9313	274.97	2353316.0
2019-02-13 14:00:00	SPY	ETF	274.98	275.15	274.97	275.133	2356684.0
2019-02-13 14:30:00	SPY	ETF	275.14	275.49	275.12	275.43	3462660.0
2019-02-13 15:00:00	SPY	ETF	275.42	275.57	275.285	275.56	4671085.0
2019-02-13 15:30:00	SPY	ETF	275.56	275.71	274.85	274.98	12258049.0
2019-02-13 16:00:00	SPY	ETF	274.98	275.0107	274.64	274.79	5392089.0
2019-02-13 16:30:00	SPY	ETF	274.79	275.08	274.69	274.71	246097.0
2019-02-13 17:00:00	SPY	ETF	274.71	274.71	274.62	274.66	84785.0
2019-02-13 17:30:00	SPY	ETF	274.67	274.7	274.46	274.64	138605.0
2019-02-13 18:00:00	SPY	ETF	274.63	274.81	274.5	274.75	81187.0
2019-02-13 18:30:00	SPY	ETF	274.81	274.81	274.65	274.81	19495.0
2019-02-13 19:00:00	SPY	ETF	274.81	275.02	274.35	274.35	79742.0
2019-02-13 19:30:00	SPY	ETF	274.38	274.6	274.35	274.47	27821.0
2019-02-13 04:00:00	QQQ	ETF	171.58	171.64	171.56	171.56	1470.0
2019-02-13 04:30:00	QQQ	ETF	171.47	171.49	171.3	171.33	4400.0
2019-02-13 05:00:00	QQQ	ETF	171.47	171.47	171.38	171.38	4200.0
2019-02-13 05:30:00	QQQ	ETF	171.37	171.55	171.37	171.55	6910.0
2019-02-13 06:00:00	QQQ	ETF	171.53	171.58	171.43	171.58	4890.0
2019-02-13 06:30:00	QQQ	ETF	171.6	171.73	171.56	171.7	7811.0
2019-02-13 07:00:00	QQQ	ETF	171.69	171.78	171.65	171.74	36328.0
2019-02-13 07:30:00	QQQ	ETF	171.75	171.84	171.69	171.7	45156.0
2019-02-13 08:00:00	QQQ	ETF	171.69	171.98	171.58	171.63	58898.0
2019-02-13 08:30:00	QQQ	ETF	171.57	171.85	171.46	171.81	197592.0
2019-02-13 09:00:00	QQQ	ETF	171.79	171.86	171.57	171.61	123590.0
2019-02-13 09:30:00	QQQ	ETF	171.63	172.16	171.4801	171.77	3857201.0
2019-02-13 10:00:00	QQQ	ETF	171.76	171.9698	171.17	171.61	2583777.0
2019-02-13 10:30:00	QQQ	ETF	171.6	171.87	171.46	171.58	2354355.0
2019-02-13 11:00:00	QQQ	ETF	171.58	171.7401	171.2609	171.28	1561431.0
2019-02-13 11:30:00	QQQ	ETF	171.27	171.35	170.96	171.345	2203623.0
2019-02-13 12:00:00	QQQ	ETF	171.34	171.44	171.16	171.24	759755.0
2019-02-13 12:30:00	QQQ	ETF	171.25	171.4	171.14	171.2825	835816.0

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

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