PREVIEW / etf_30min / 2010-03-31

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-03-31.parquet
  size:    245 KB
  rows:    8,309

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-03-31 04:30:00	SPY	ETF	117.3	117.3	117.3	117.3	2500.0
2010-03-31 05:00:00	SPY	ETF	117.28	117.28	117.28	117.28	100.0
2010-03-31 05:30:00	SPY	ETF	117.27	117.27	117.27	117.27	200.0
2010-03-31 06:00:00	SPY	ETF	117.18	117.24	117.18	117.24	3400.0
2010-03-31 06:30:00	SPY	ETF	117.32	117.32	117.25	117.3	46577.0
2010-03-31 07:00:00	SPY	ETF	117.3	117.31	117.2	117.29	240863.0
2010-03-31 07:30:00	SPY	ETF	117.31	117.35	117.29	117.32	119535.0
2010-03-31 08:00:00	SPY	ETF	117.33	117.42	116.93	117.0	2021970.0
2010-03-31 08:30:00	SPY	ETF	117.0	117.03	116.75	116.91	1130965.0
2010-03-31 09:00:00	SPY	ETF	116.9	116.97	116.87	116.95	743379.0
2010-03-31 09:30:00	SPY	ETF	116.95	117.175	116.61	116.81	27317619.0
2010-03-31 10:00:00	SPY	ETF	116.84	117.31	116.82	117.23	13283008.0
2010-03-31 10:30:00	SPY	ETF	117.23	117.35	117.08	117.17	12286855.0
2010-03-31 11:00:00	SPY	ETF	117.17	117.24	116.9	117.2	8824589.0
2010-03-31 11:30:00	SPY	ETF	117.2	117.45	117.17	117.38	9445887.0
2010-03-31 12:00:00	SPY	ETF	117.388	117.49	117.28	117.38	5124377.0
2010-03-31 12:30:00	SPY	ETF	117.38	117.51	117.3	117.36	4879882.0
2010-03-31 13:00:00	SPY	ETF	117.36	117.37	117.25	117.37	5490990.0
2010-03-31 13:30:00	SPY	ETF	117.37	117.43	117.31	117.4	3871012.0
2010-03-31 14:00:00	SPY	ETF	117.4	117.52	117.36	117.42	5079673.0
2010-03-31 14:30:00	SPY	ETF	117.42	117.46	117.05	117.13	9582554.0
2010-03-31 15:00:00	SPY	ETF	117.13	117.13	116.85	117.08	13107107.0
2010-03-31 15:30:00	SPY	ETF	117.08	117.11	116.75	116.99	25915570.0
2010-03-31 16:00:00	SPY	ETF	116.98	117.3714	116.83	117.17	10583747.0
2010-03-31 16:30:00	SPY	ETF	117.16	117.373	117.0	117.15	753186.0
2010-03-31 17:00:00	SPY	ETF	117.16	117.19	117.13	117.19	167268.0
2010-03-31 17:30:00	SPY	ETF	117.18	117.23	117.14	117.2	61981.0
2010-03-31 18:00:00	SPY	ETF	117.19	117.24	117.19	117.21	26586.0
2010-03-31 18:30:00	SPY	ETF	117.19	117.28	117.18	117.28	53875.0
2010-03-31 19:00:00	SPY	ETF	117.28	117.28	117.24	117.25	27157.0
2010-03-31 19:30:00	SPY	ETF	117.26	117.33	117.23	117.3	48101.0
2010-03-31 07:00:00	QQQ	ETF	48.33	48.33	48.33	48.33	600.0
2010-03-31 07:30:00	QQQ	ETF	48.34	48.34	48.34	48.34	2400.0
2010-03-31 08:00:00	QQQ	ETF	48.35	48.39	48.22	48.24	865011.0
2010-03-31 08:30:00	QQQ	ETF	48.24	48.25	48.13	48.21	262252.0
2010-03-31 09:00:00	QQQ	ETF	48.2	48.26	48.19	48.23	220541.0
2010-03-31 09:30:00	QQQ	ETF	48.23	48.36	48.1	48.1799	10426585.0
2010-03-31 10:00:00	QQQ	ETF	48.18	48.34	48.16	48.3	3520877.0
2010-03-31 10:30:00	QQQ	ETF	48.3	48.38	48.26	48.3299	3966124.0
2010-03-31 11:00:00	QQQ	ETF	48.325	48.34	48.25	48.31	1646825.0
2010-03-31 11:30:00	QQQ	ETF	48.3	48.42	48.29	48.36	5506224.0
2010-03-31 12:00:00	QQQ	ETF	48.365	48.41	48.33	48.3419	1991535.0
2010-03-31 12:30:00	QQQ	ETF	48.345	48.4	48.32	48.34	1166612.0
2010-03-31 13:00:00	QQQ	ETF	48.34	48.38	48.31	48.38	2069745.0
2010-03-31 13:30:00	QQQ	ETF	48.38	48.4	48.35	48.39	1401709.0
2010-03-31 14:00:00	QQQ	ETF	48.4	48.45	48.37	48.4266	2345139.0
2010-03-31 14:30:00	QQQ	ETF	48.42	48.43	48.2	48.24	4704592.0
2010-03-31 15:00:00	QQQ	ETF	48.24	48.44	48.14	48.2138	4479444.0
2010-03-31 15:30:00	QQQ	ETF	48.215	48.23	48.07	48.18	9746542.0
2010-03-31 16:00:00	QQQ	ETF	48.18	48.349	48.04	48.21	2935136.0

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

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