PREVIEW / etf_30min / 2018-01-22

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-01-22.parquet
  size:    490 KB
  rows:    16,986

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-01-22 04:00:00	SPY	ETF	280.0	280.0	279.8	279.8	17042.0
2018-01-22 04:30:00	SPY	ETF	279.96	279.96	279.94	279.94	1100.0
2018-01-22 05:00:00	SPY	ETF	279.89	279.96	279.84	279.84	8400.0
2018-01-22 05:30:00	SPY	ETF	279.84	279.94	279.84	279.94	7376.0
2018-01-22 06:00:00	SPY	ETF	279.97	280.1	279.97	280.04	22893.0
2018-01-22 06:30:00	SPY	ETF	280.04	280.13	280.02	280.13	34283.0
2018-01-22 07:00:00	SPY	ETF	280.1	280.15	280.05	280.07	54430.0
2018-01-22 07:30:00	SPY	ETF	280.11	280.29	280.11	280.25	144511.0
2018-01-22 08:00:00	SPY	ETF	280.27	280.44	279.77	280.38	223618.0
2018-01-22 08:30:00	SPY	ETF	280.4	280.41	280.01	280.04	266226.0
2018-01-22 09:00:00	SPY	ETF	280.05	280.16	279.95	280.14	235085.0
2018-01-22 09:30:00	SPY	ETF	280.17	280.76	280.11	280.665	3976265.0
2018-01-22 10:00:00	SPY	ETF	280.66	281.43	280.59	281.29	5634611.0
2018-01-22 10:30:00	SPY	ETF	281.3	281.39	280.99	281.0	4575407.0
2018-01-22 11:00:00	SPY	ETF	281.0	281.265	280.92	280.93	2831856.0
2018-01-22 11:30:00	SPY	ETF	280.93	281.49	280.89	281.45	2548283.0
2018-01-22 12:00:00	SPY	ETF	281.44	281.8	281.35	281.73	3263726.0
2018-01-22 12:30:00	SPY	ETF	281.73	281.96	281.705	281.71	3042584.0
2018-01-22 13:00:00	SPY	ETF	281.71	281.88	281.611	281.76	2899243.0
2018-01-22 13:30:00	SPY	ETF	281.77	281.89	281.68	281.82	4108610.0
2018-01-22 14:00:00	SPY	ETF	281.82	281.865	281.45	281.62	4066344.0
2018-01-22 14:30:00	SPY	ETF	281.62	281.87	281.59	281.71	1738094.0
2018-01-22 15:00:00	SPY	ETF	281.71	281.98	281.68	281.9	3173482.0
2018-01-22 15:30:00	SPY	ETF	281.91	282.68	281.83	282.67	14922030.0
2018-01-22 16:00:00	SPY	ETF	282.66	282.79	282.62	282.7	9074940.0
2018-01-22 16:30:00	SPY	ETF	282.7	282.91	282.669	282.71	2788053.0
2018-01-22 17:00:00	SPY	ETF	282.7	282.73	281.2194	282.73	8366441.0
2018-01-22 17:30:00	SPY	ETF	282.74	282.76	282.7	282.7	44328.0
2018-01-22 18:00:00	SPY	ETF	282.7	282.77	282.58	282.61	93763.0
2018-01-22 18:30:00	SPY	ETF	282.62	282.66	282.62	282.63	4003.0
2018-01-22 19:00:00	SPY	ETF	282.66	282.66	282.58	282.58	27316.0
2018-01-22 19:30:00	SPY	ETF	282.64	282.77	282.62	282.75	21613.0
2018-01-22 04:00:00	QQQ	ETF	166.21	166.22	166.21	166.22	416.0
2018-01-22 04:30:00	QQQ	ETF	166.16	166.25	166.16	166.23	3700.0
2018-01-22 05:00:00	QQQ	ETF	166.2	166.25	166.16	166.16	8807.0
2018-01-22 05:30:00	QQQ	ETF	166.17	166.25	166.17	166.21	17530.0
2018-01-22 06:00:00	QQQ	ETF	166.27	166.34	166.25	166.25	2615.0
2018-01-22 06:30:00	QQQ	ETF	166.36	166.36	166.36	166.36	1097.0
2018-01-22 07:00:00	QQQ	ETF	166.27	166.33	166.26	166.3	21761.0
2018-01-22 07:30:00	QQQ	ETF	166.34	166.36	166.3	166.36	12257.0
2018-01-22 08:00:00	QQQ	ETF	166.35	166.45	166.26	166.44	71837.0
2018-01-22 08:30:00	QQQ	ETF	166.45	166.45	166.25	166.28	40362.0
2018-01-22 09:00:00	QQQ	ETF	166.31	166.32	166.13	166.26	101989.0
2018-01-22 09:30:00	QQQ	ETF	166.24	166.67	166.09	166.6	2624871.0
2018-01-22 10:00:00	QQQ	ETF	166.59	167.24	166.5233	167.165	2756481.0
2018-01-22 10:30:00	QQQ	ETF	167.17	167.405	167.1	167.1562	1579692.0
2018-01-22 11:00:00	QQQ	ETF	167.15	167.335	167.13	167.18	793703.0
2018-01-22 11:30:00	QQQ	ETF	167.17	167.5252	167.13	167.51	914908.0
2018-01-22 12:00:00	QQQ	ETF	167.5	167.68	167.425	167.65	1180416.0
2018-01-22 12:30:00	QQQ	ETF	167.65	167.77	167.62	167.625	1169596.0

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

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