PREVIEW / etf_30min / 2009-08-25

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-08-25.parquet
  size:    232 KB
  rows:    7,686

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-08-25 04:00:00	SPY	ETF	102.97	102.97	102.97	102.97	200.0
2009-08-25 04:30:00	SPY	ETF	102.89	102.93	102.87	102.93	1400.0
2009-08-25 05:00:00	SPY	ETF	103.08	103.14	103.08	103.09	8200.0
2009-08-25 05:30:00	SPY	ETF	103.09	103.09	103.09	103.09	100.0
2009-08-25 06:00:00	SPY	ETF	103.09	103.11	103.07	103.07	15600.0
2009-08-25 06:30:00	SPY	ETF	103.04	103.04	102.99	103.04	2880.0
2009-08-25 07:00:00	SPY	ETF	103.05	103.16	103.0	103.12	41535.0
2009-08-25 07:30:00	SPY	ETF	103.14	103.48	103.14	103.48	786712.0
2009-08-25 08:00:00	SPY	ETF	103.48	103.59	102.65	103.44	1960029.0
2009-08-25 08:30:00	SPY	ETF	103.45	103.54	102.77	103.51	1116483.0
2009-08-25 09:00:00	SPY	ETF	103.52	103.72	102.36	103.37	2725832.0
2009-08-25 09:30:00	SPY	ETF	103.37	103.79	103.12	103.68	20689323.0
2009-08-25 10:00:00	SPY	ETF	103.69	104.26	103.12	103.16	38602165.0
2009-08-25 10:30:00	SPY	ETF	103.15	103.55	103.14	103.51	13646696.0
2009-08-25 11:00:00	SPY	ETF	103.5	103.74	103.47	103.71	8229361.0
2009-08-25 11:30:00	SPY	ETF	103.71	103.86	103.64	103.72	8044694.0
2009-08-25 12:00:00	SPY	ETF	103.72	103.93	103.69	103.8907	13842233.0
2009-08-25 12:30:00	SPY	ETF	103.89	104.03	103.54	103.56	9081505.0
2009-08-25 13:00:00	SPY	ETF	103.562	103.67	103.22	103.29	10636519.0
2009-08-25 13:30:00	SPY	ETF	103.29	103.44	103.18	103.25	10885982.0
2009-08-25 14:00:00	SPY	ETF	103.25	103.44	103.13	103.33	9351812.0
2009-08-25 14:30:00	SPY	ETF	103.34	103.36	102.94	103.22	17149446.0
2009-08-25 15:00:00	SPY	ETF	103.23	103.5	103.22	103.35	10234296.0
2009-08-25 15:30:00	SPY	ETF	103.35	103.365	103.03	103.16	20139267.0
2009-08-25 16:00:00	SPY	ETF	103.16	103.8652	103.02	103.11	11121190.0
2009-08-25 16:30:00	SPY	ETF	103.08	103.2194	103.0	103.05	3007189.0
2009-08-25 17:00:00	SPY	ETF	103.05	103.2122	103.0	103.2122	307164.0
2009-08-25 17:30:00	SPY	ETF	103.02	103.4849	102.99	103.01	464949.0
2009-08-25 18:00:00	SPY	ETF	103.0	103.14	102.91	102.92	274339.0
2009-08-25 18:30:00	SPY	ETF	102.92	102.92	102.9	102.92	37710.0
2009-08-25 19:00:00	SPY	ETF	102.92	102.92	102.75	102.75	172707.0
2009-08-25 19:30:00	SPY	ETF	102.75	102.77	102.69	102.73	84190.0
2009-08-25 05:00:00	QQQ	ETF	40.26	40.31	40.26	40.27	1404.0
2009-08-25 06:00:00	QQQ	ETF	40.29	40.29	40.29	40.29	339.0
2009-08-25 06:30:00	QQQ	ETF	40.26	40.27	40.24	40.24	1224.0
2009-08-25 07:00:00	QQQ	ETF	40.25	40.3	40.25	40.3	34700.0
2009-08-25 07:30:00	QQQ	ETF	40.3	40.43	40.29	40.41	46367.0
2009-08-25 08:00:00	QQQ	ETF	40.4	40.45	40.39	40.41	280585.0
2009-08-25 08:30:00	QQQ	ETF	40.39	40.45	39.975	40.43	833639.0
2009-08-25 09:00:00	QQQ	ETF	40.42	40.5	40.34	40.35	851285.0
2009-08-25 09:30:00	QQQ	ETF	40.34	40.61	40.26	40.61	11842597.0
2009-08-25 10:00:00	QQQ	ETF	40.54	40.76	40.34	40.36	18063613.0
2009-08-25 10:30:00	QQQ	ETF	40.36	40.55	40.35	40.48	8953490.0
2009-08-25 11:00:00	QQQ	ETF	40.48	40.55	40.46	40.54	2565384.0
2009-08-25 11:30:00	QQQ	ETF	40.54	40.62	40.51	40.57	2655345.0
2009-08-25 12:00:00	QQQ	ETF	40.58	40.66	40.55	40.64	1951346.0
2009-08-25 12:30:00	QQQ	ETF	40.64	40.6801	40.46	40.48	7227822.0
2009-08-25 13:00:00	QQQ	ETF	40.47	40.52	40.36	40.4	4695660.0
2009-08-25 13:30:00	QQQ	ETF	40.39	40.6167	40.34	40.3778	3827706.0
2009-08-25 14:00:00	QQQ	ETF	40.38	40.435	40.33	40.38	3140632.0

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

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