PREVIEW / etf_30min / 2018-02-21

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-02-21.parquet
  size:    480 KB
  rows:    16,449

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-02-21 04:00:00	SPY	ETF	271.15	271.15	270.64	271.12	21764.0
2018-02-21 04:30:00	SPY	ETF	271.16	271.21	270.81	270.96	20050.0
2018-02-21 05:00:00	SPY	ETF	271.01	271.07	270.8	270.9	32633.0
2018-02-21 05:30:00	SPY	ETF	270.93	271.16	270.88	270.98	17169.0
2018-02-21 06:00:00	SPY	ETF	271.01	271.06	270.77	270.93	12740.0
2018-02-21 06:30:00	SPY	ETF	270.93	271.17	270.76	271.17	35437.0
2018-02-21 07:00:00	SPY	ETF	271.18	271.34	271.18	271.2	64699.0
2018-02-21 07:30:00	SPY	ETF	271.23	271.31	271.14	271.29	27090.0
2018-02-21 08:00:00	SPY	ETF	271.23	271.57	270.82	271.5	153613.0
2018-02-21 08:30:00	SPY	ETF	271.54	271.72	271.4	271.57	701849.0
2018-02-21 09:00:00	SPY	ETF	271.58	271.88	271.4	271.86	191699.0
2018-02-21 09:30:00	SPY	ETF	271.9	273.06	271.58	272.68	6659383.0
2018-02-21 10:00:00	SPY	ETF	272.69	273.03	272.35	272.79	3002440.0
2018-02-21 10:30:00	SPY	ETF	272.78	273.4	272.72	273.32	2683360.0
2018-02-21 11:00:00	SPY	ETF	273.29	273.41	272.85	273.3701	1826603.0
2018-02-21 11:30:00	SPY	ETF	273.37	273.64	273.04	273.102	1948467.0
2018-02-21 12:00:00	SPY	ETF	273.1	273.2399	272.58	272.79	2111425.0
2018-02-21 12:30:00	SPY	ETF	272.79	273.33	272.69	273.3	1797865.0
2018-02-21 13:00:00	SPY	ETF	273.3	273.36	273.08	273.27	1450904.0
2018-02-21 13:30:00	SPY	ETF	273.27	273.48	272.95	273.31	2203758.0
2018-02-21 14:00:00	SPY	ETF	273.31	274.72	272.99	274.03	11877620.0
2018-02-21 14:30:00	SPY	ETF	274.03	274.28	272.81	273.23	7238871.0
2018-02-21 15:00:00	SPY	ETF	273.25	273.29	271.36	272.26	16539325.0
2018-02-21 15:30:00	SPY	ETF	272.26	272.71	269.98	270.0	18392284.0
2018-02-21 16:00:00	SPY	ETF	269.99	270.08	269.31	269.9	13539825.0
2018-02-21 16:30:00	SPY	ETF	269.89	272.23	269.63	269.84	2577702.0
2018-02-21 17:00:00	SPY	ETF	269.88	270.05	269.66	269.66	209533.0
2018-02-21 17:30:00	SPY	ETF	269.7	269.82	269.67	269.8	798692.0
2018-02-21 18:00:00	SPY	ETF	269.78	269.87	269.25	269.56	98385.0
2018-02-21 18:30:00	SPY	ETF	269.6	269.65	269.0	269.15	136229.0
2018-02-21 19:00:00	SPY	ETF	269.14	269.59	269.14	269.48	121573.0
2018-02-21 19:30:00	SPY	ETF	269.47	269.58	269.06	269.24	90795.0
2018-02-21 04:00:00	QQQ	ETF	165.25	165.5	165.17	165.49	7080.0
2018-02-21 04:30:00	QQQ	ETF	165.46	165.63	165.32	165.32	2600.0
2018-02-21 05:00:00	QQQ	ETF	165.25	165.31	165.21	165.28	11600.0
2018-02-21 05:30:00	QQQ	ETF	165.46	165.46	165.28	165.37	41100.0
2018-02-21 06:00:00	QQQ	ETF	165.31	165.39	165.31	165.39	4560.0
2018-02-21 06:30:00	QQQ	ETF	165.35	165.6	165.27	165.57	15534.0
2018-02-21 07:00:00	QQQ	ETF	165.61	165.8	165.61	165.71	29200.0
2018-02-21 07:30:00	QQQ	ETF	165.71	165.73	165.62	165.71	18480.0
2018-02-21 08:00:00	QQQ	ETF	165.58	165.93	165.22	165.88	64497.0
2018-02-21 08:30:00	QQQ	ETF	165.89	166.04	165.29	165.91	88371.0
2018-02-21 09:00:00	QQQ	ETF	166.0	166.11	165.9	166.05	112000.0
2018-02-21 09:30:00	QQQ	ETF	166.05	166.44	165.8	166.2	3056087.0
2018-02-21 10:00:00	QQQ	ETF	166.2	166.6	165.9677	166.52	1581073.0
2018-02-21 10:30:00	QQQ	ETF	166.52	166.76	166.3725	166.66	1578638.0
2018-02-21 11:00:00	QQQ	ETF	166.67	166.95	166.44	166.93	1171446.0
2018-02-21 11:30:00	QQQ	ETF	166.92	167.1501	166.67	166.73	1176877.0
2018-02-21 12:00:00	QQQ	ETF	166.73	166.83	166.32	166.4335	1037365.0
2018-02-21 12:30:00	QQQ	ETF	166.43	166.66	166.325	166.64	806414.0

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

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