PREVIEW / etf_30min / 2018-03-19

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-03-19.parquet
  size:    473 KB
  rows:    16,274

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-03-19 04:00:00	SPY	ETF	273.78	273.78	272.44	272.44	38962.0
2018-03-19 04:30:00	SPY	ETF	272.37	272.7	272.18	272.7	23902.0
2018-03-19 05:00:00	SPY	ETF	272.58	272.99	272.58	272.97	41003.0
2018-03-19 05:30:00	SPY	ETF	272.96	273.16	272.88	273.1	34891.0
2018-03-19 06:00:00	SPY	ETF	273.14	273.14	272.91	273.04	11476.0
2018-03-19 06:30:00	SPY	ETF	273.03	273.12	272.93	272.95	36747.0
2018-03-19 07:00:00	SPY	ETF	272.98	273.02	272.69	272.75	83870.0
2018-03-19 07:30:00	SPY	ETF	272.81	273.02	272.68	273.0	110801.0
2018-03-19 08:00:00	SPY	ETF	273.0	273.58	272.7	273.26	210720.0
2018-03-19 08:30:00	SPY	ETF	273.29	274.2	273.1	273.13	438954.0
2018-03-19 09:00:00	SPY	ETF	273.15	273.4	272.92	273.36	537570.0
2018-03-19 09:30:00	SPY	ETF	273.35	274.3957	272.27	272.7	8228566.0
2018-03-19 10:00:00	SPY	ETF	272.71	272.78	272.03	272.55	4446162.0
2018-03-19 10:30:00	SPY	ETF	272.55	272.67	271.44	271.6	4512155.0
2018-03-19 11:00:00	SPY	ETF	271.6	271.795	271.11	271.45	5076311.0
2018-03-19 11:30:00	SPY	ETF	271.45	271.475	270.17	270.4	5842595.0
2018-03-19 12:00:00	SPY	ETF	270.4	270.69	269.96	270.51	6068028.0
2018-03-19 12:30:00	SPY	ETF	270.53	270.63	269.67	270.13	4761879.0
2018-03-19 13:00:00	SPY	ETF	270.135	270.23	268.81	269.14	8568830.0
2018-03-19 13:30:00	SPY	ETF	269.14	269.9	269.0007	269.85	9077455.0
2018-03-19 14:00:00	SPY	ETF	269.85	270.145	269.26	269.58	4606914.0
2018-03-19 14:30:00	SPY	ETF	269.58	269.8	268.62	269.58	8123343.0
2018-03-19 15:00:00	SPY	ETF	269.58	270.18	269.05	269.68	8174245.0
2018-03-19 15:30:00	SPY	ETF	269.67	270.79	269.37	270.49	16053149.0
2018-03-19 16:00:00	SPY	ETF	270.49	271.24	270.49	271.13	11080813.0
2018-03-19 16:30:00	SPY	ETF	271.15	271.32	270.49	271.13	518590.0
2018-03-19 17:00:00	SPY	ETF	271.12	271.22	270.49	271.1	230446.0
2018-03-19 17:30:00	SPY	ETF	271.05	271.08	270.65	270.94	226367.0
2018-03-19 18:00:00	SPY	ETF	270.98	271.02	270.72	270.72	125313.0
2018-03-19 18:30:00	SPY	ETF	270.71	270.94	270.67	270.79	214424.0
2018-03-19 19:00:00	SPY	ETF	270.88	270.9	270.6	270.61	73014.0
2018-03-19 19:30:00	SPY	ETF	270.64	270.78	270.61	270.74	119560.0
2018-03-19 04:00:00	QQQ	ETF	169.72	169.78	168.32	168.36	62305.0
2018-03-19 04:30:00	QQQ	ETF	168.28	168.7	168.27	168.7	12145.0
2018-03-19 05:00:00	QQQ	ETF	168.68	168.95	168.59	168.95	14739.0
2018-03-19 05:30:00	QQQ	ETF	168.84	168.99	168.78	168.91	12629.0
2018-03-19 06:00:00	QQQ	ETF	169.01	169.01	168.59	168.7	11872.0
2018-03-19 06:30:00	QQQ	ETF	168.67	168.67	168.51	168.64	44584.0
2018-03-19 07:00:00	QQQ	ETF	168.64	168.78	168.46	168.53	233950.0
2018-03-19 07:30:00	QQQ	ETF	168.6	168.91	168.54	168.87	286461.0
2018-03-19 08:00:00	QQQ	ETF	168.83	169.21	168.51	169.21	127175.0
2018-03-19 08:30:00	QQQ	ETF	169.22	169.25	169.04	169.05	129605.0
2018-03-19 09:00:00	QQQ	ETF	169.04	169.23	168.94	169.18	1400588.0
2018-03-19 09:30:00	QQQ	ETF	169.19	169.22	168.471	168.85	5900865.0
2018-03-19 10:00:00	QQQ	ETF	168.84	168.96	168.32	168.74	4832970.0
2018-03-19 10:30:00	QQQ	ETF	168.7399	168.77	167.61	167.74	3485971.0
2018-03-19 11:00:00	QQQ	ETF	167.73	167.8	167.19	167.41	3059297.0
2018-03-19 11:30:00	QQQ	ETF	167.415	167.43	166.1	166.25	4474901.0
2018-03-19 12:00:00	QQQ	ETF	166.24	166.78	166.17	166.77	3858312.0
2018-03-19 12:30:00	QQQ	ETF	166.78	166.87	165.96	166.57	2833941.0

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

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