PREVIEW / etf_30min / 2009-11-25

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-11-25.parquet
  size:    229 KB
  rows:    7,650

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
2009-11-25 04:00:00	SPY	ETF	111.18	111.27	111.16	111.24	6400.0
2009-11-25 04:30:00	SPY	ETF	111.26	111.44	111.26	111.44	2800.0
2009-11-25 05:00:00	SPY	ETF	111.34	111.37	111.3	111.34	5750.0
2009-11-25 05:30:00	SPY	ETF	111.31	111.37	111.14	111.18	3100.0
2009-11-25 06:00:00	SPY	ETF	111.14	111.31	111.14	111.31	1250.0
2009-11-25 06:30:00	SPY	ETF	111.37	111.37	111.34	111.34	600.0
2009-11-25 07:00:00	SPY	ETF	111.31	111.32	111.18	111.28	108439.0
2009-11-25 07:30:00	SPY	ETF	111.3	111.39	111.24	111.35	176387.0
2009-11-25 08:00:00	SPY	ETF	111.34	111.34	111.2	111.29	617331.0
2009-11-25 08:30:00	SPY	ETF	111.3	111.61	111.19	111.33	2833865.0
2009-11-25 09:00:00	SPY	ETF	111.33	111.36	111.04	111.16	2811350.0
2009-11-25 09:30:00	SPY	ETF	111.17	111.21	110.82	111.015	13407109.0
2009-11-25 10:00:00	SPY	ETF	111.04	111.27	110.95	111.04	11587073.0
2009-11-25 10:30:00	SPY	ETF	111.04	111.32	111.04	111.16	7733846.0
2009-11-25 11:00:00	SPY	ETF	111.16	111.41	111.145	111.37	7389468.0
2009-11-25 11:30:00	SPY	ETF	111.36	111.48	111.32	111.37	4283399.0
2009-11-25 12:00:00	SPY	ETF	111.38	111.41	111.18	111.27	9541296.0
2009-11-25 12:30:00	SPY	ETF	111.27	111.4	111.14	111.24	3117251.0
2009-11-25 13:00:00	SPY	ETF	111.24	111.32	111.2	111.26	2615495.0
2009-11-25 13:30:00	SPY	ETF	111.2601	111.32	111.2	111.31	2557060.0
2009-11-25 14:00:00	SPY	ETF	111.31	111.37	111.18	111.3325	6868682.0
2009-11-25 14:30:00	SPY	ETF	111.34	111.5	111.13	111.42	5826058.0
2009-11-25 15:00:00	SPY	ETF	111.425	111.47	111.33	111.4199	3798667.0
2009-11-25 15:30:00	SPY	ETF	111.42	111.44	111.28	111.37	11212011.0
2009-11-25 16:00:00	SPY	ETF	111.37	111.44	110.9354	111.4	11240242.0
2009-11-25 16:30:00	SPY	ETF	111.37	111.4	111.34	111.38	1206973.0
2009-11-25 17:00:00	SPY	ETF	111.36	111.47	111.32	111.38	331507.0
2009-11-25 17:30:00	SPY	ETF	111.41	111.42	111.37	111.37	8033.0
2009-11-25 18:00:00	SPY	ETF	111.37	111.42	111.36	111.36	13087.0
2009-11-25 18:30:00	SPY	ETF	111.35	111.35	111.3	111.33	29746.0
2009-11-25 19:00:00	SPY	ETF	111.33	111.35	111.32	111.35	40046.0
2009-11-25 19:30:00	SPY	ETF	111.33	111.35	111.32	111.35	8922.0
2009-11-25 04:00:00	QQQ	ETF	44.15	44.15	44.14	44.14	420.0
2009-11-25 04:30:00	QQQ	ETF	44.2	44.2	44.2	44.2	250.0
2009-11-25 05:00:00	QQQ	ETF	44.19	44.19	44.19	44.19	3000.0
2009-11-25 06:30:00	QQQ	ETF	44.24	44.24	44.24	44.24	100.0
2009-11-25 07:00:00	QQQ	ETF	44.18	44.21	44.18	44.18	7900.0
2009-11-25 07:30:00	QQQ	ETF	44.2	44.22	44.2	44.22	7400.0
2009-11-25 08:00:00	QQQ	ETF	44.21	44.22	44.17	44.2	93790.0
2009-11-25 08:30:00	QQQ	ETF	44.21	44.31	44.19	44.22	835884.0
2009-11-25 09:00:00	QQQ	ETF	44.23	44.23	44.11	44.13	691537.0
2009-11-25 09:30:00	QQQ	ETF	44.14	44.15	44.01	44.09	6445513.0
2009-11-25 10:00:00	QQQ	ETF	44.09	44.2	44.0617	44.09	5853187.0
2009-11-25 10:30:00	QQQ	ETF	44.1	44.18	44.09	44.1326	2114999.0
2009-11-25 11:00:00	QQQ	ETF	44.13	44.21	44.13	44.17	2609134.0
2009-11-25 11:30:00	QQQ	ETF	44.17	44.22	44.16	44.18	1165343.0
2009-11-25 12:00:00	QQQ	ETF	44.18	44.19	44.09	44.1376	1479755.0
2009-11-25 12:30:00	QQQ	ETF	44.13	44.13	44.07	44.11	1484245.0
2009-11-25 13:00:00	QQQ	ETF	44.1	44.13	44.09	44.12	781925.0
2009-11-25 13:30:00	QQQ	ETF	44.12	44.17	44.11	44.1675	1073726.0

> showing 50 of 7,650 rows — these rows as CSV

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