PREVIEW / etf_30min / 2010-05-12

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-05-12.parquet
  size:    263 KB
  rows:    8,682

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
2010-05-12 04:00:00	SPY	ETF	116.12	116.12	116.12	116.12	100.0
2010-05-12 04:30:00	SPY	ETF	115.89	115.89	115.87	115.87	3718.0
2010-05-12 05:00:00	SPY	ETF	115.84	115.84	115.64	115.75	6000.0
2010-05-12 05:30:00	SPY	ETF	115.77	115.77	115.49	115.64	4200.0
2010-05-12 06:00:00	SPY	ETF	115.77	116.01	115.77	115.9	3800.0
2010-05-12 06:30:00	SPY	ETF	115.81	116.14	115.77	116.1	155600.0
2010-05-12 07:00:00	SPY	ETF	116.05	116.23	115.96	116.2	273735.0
2010-05-12 07:30:00	SPY	ETF	116.22	116.45	116.18	116.42	617252.0
2010-05-12 08:00:00	SPY	ETF	116.4	116.45	115.5	116.25	1584917.0
2010-05-12 08:30:00	SPY	ETF	116.25	116.49	116.14	116.38	1549299.0
2010-05-12 09:00:00	SPY	ETF	116.36	116.4	116.19	116.29	1221731.0
2010-05-12 09:30:00	SPY	ETF	116.29	116.83	116.09	116.82	28543151.0
2010-05-12 10:00:00	SPY	ETF	116.82	117.04	116.632	116.96	19269908.0
2010-05-12 10:30:00	SPY	ETF	116.96	117.01	116.56	116.84	12432708.0
2010-05-12 11:00:00	SPY	ETF	116.8475	117.18	116.454	116.47	21399443.0
2010-05-12 11:30:00	SPY	ETF	116.46	116.85	116.4	116.83	15199700.0
2010-05-12 12:00:00	SPY	ETF	116.83	117.05	116.79	116.99	9134625.0
2010-05-12 12:30:00	SPY	ETF	116.99	117.15	116.86	117.12	7467945.0
2010-05-12 13:00:00	SPY	ETF	117.12	117.42	117.03	117.15	13459985.0
2010-05-12 13:30:00	SPY	ETF	117.15	117.23	116.93	116.94	13092065.0
2010-05-12 14:00:00	SPY	ETF	116.93	117.37	116.89	117.36	11428269.0
2010-05-12 14:30:00	SPY	ETF	117.37	117.45	117.05	117.36	12057491.0
2010-05-12 15:00:00	SPY	ETF	117.36	117.62	117.25	117.35	15592091.0
2010-05-12 15:30:00	SPY	ETF	117.35	117.55	117.12	117.45	22940717.0
2010-05-12 16:00:00	SPY	ETF	117.45	117.54	116.43	117.39	17420410.0
2010-05-12 16:30:00	SPY	ETF	117.39	117.42	115.861	117.28	8354788.0
2010-05-12 17:00:00	SPY	ETF	117.28	117.48	115.861	117.41	1192475.0
2010-05-12 17:30:00	SPY	ETF	117.4	117.43	117.35	117.4	31291.0
2010-05-12 18:00:00	SPY	ETF	117.4	117.47	117.3	117.31	221071.0
2010-05-12 18:30:00	SPY	ETF	117.3	117.32	117.24	117.24	14578.0
2010-05-12 19:00:00	SPY	ETF	117.25	117.29	117.25	117.29	48585.0
2010-05-12 19:30:00	SPY	ETF	117.3	117.36	117.3	117.36	25590.0
2010-05-12 20:00:00	SPY	ETF	117.32	117.32	117.32	117.32	200.0
2010-05-12 04:00:00	QQQ	ETF	47.77	47.77	47.77	47.77	440.0
2010-05-12 06:00:00	QQQ	ETF	47.74	47.74	47.68	47.68	300.0
2010-05-12 06:30:00	QQQ	ETF	47.74	47.79	47.72	47.79	3613.0
2010-05-12 07:00:00	QQQ	ETF	47.78	47.87	47.73	47.85	10167.0
2010-05-12 07:30:00	QQQ	ETF	47.85	47.96	47.84	47.94	281761.0
2010-05-12 08:00:00	QQQ	ETF	47.94	47.96	47.86	47.89	460712.0
2010-05-12 08:30:00	QQQ	ETF	47.88	47.99	47.85	47.97	1009735.0
2010-05-12 09:00:00	QQQ	ETF	47.97	47.99	47.89	47.98	911035.0
2010-05-12 09:30:00	QQQ	ETF	47.98	48.26	47.9	48.2465	11826329.0
2010-05-12 10:00:00	QQQ	ETF	48.2478	48.35	48.21	48.35	7653102.0
2010-05-12 10:30:00	QQQ	ETF	48.35	48.43	48.2	48.36	6510003.0
2010-05-12 11:00:00	QQQ	ETF	48.36	48.48	48.21	48.22	5279263.0
2010-05-12 11:30:00	QQQ	ETF	48.22	48.37	48.18	48.35	4331093.0
2010-05-12 12:00:00	QQQ	ETF	48.35	48.43	48.32	48.42	2651950.0
2010-05-12 12:30:00	QQQ	ETF	48.43	48.45	48.36	48.44	3104723.0
2010-05-12 13:00:00	QQQ	ETF	48.4399	48.56	48.39	48.49	4219001.0
2010-05-12 13:30:00	QQQ	ETF	48.49	48.5211	48.37	48.3999	5959769.0

> showing 50 of 8,682 rows — these rows as CSV

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